I'm assuming here it's the stock factory fitting and you mean the fuel hose and not the fuel pipe. Hoses are flexible and made of rubber/plastic, pipes are rigid and made of metal/PVC. If the "red adhesive" is holding the fuel hose connector onto the fuel pipe that's all wrong, such are the joys of owning a used motorcycle fettled by folk not allowed spanners. If I was a gambling man I'd wager that "red adhesive" was an unnecessary smear of Hermetite, Hylotyte, RTV silicone or something similar. Clean it all off and refit the fuel hose connector to the fuel pipe dry. The manuals suggest replacing the retainer clips, I'd reuse them, your choice) if its difficult to slide the hose connector onto the fuel pipe give the fuel pipe a light spray of maintenance spray such as
Triple QX maintenance spray or if you must reassuringly expensive WD40.
Having typed all that it now occurs to me you may be referring to the fuel tank breather hose or the fuel tank drain hose, both of these hoses just push on with no need to use adhesives, clamps or sealants, the assumption here is the replacement hose is of the correct composition and internal diameter.
Now I'm curious to know what was the damage to the "under tank fuel pipe" and which pipe (or hose) it was?
If you’re allowed spanners and you haven't already, you may want to
download the Honda Workshop and Owners Manuals here. Section 6 of the workshop manual FUEL SYSTEM (PGM_FI) should be an interesting read.