I've had a little water in the drivers foot well for a while now, today it's gotten worse. The o/s carpet and headliner are saturated, water is every where

I had a quick look at the sunroof drains, and found the o/s front drain point has corroded. It is still attached to the water hose, but there is now a gap around the drain mount - so the water now drains down this gap (onto the headlining), and not into the water hose.
I'm not sure how to fix the water hose mounting point? How is the water hose attached to the drain?
From my 2 minute look at lunchtime, It looks like I should cut out the rot, make a new piece, weld in and paint?
Is this over kill? Can it / should it be repaired with a combo of silicone and fiberglass?
Has anyone had to make a similar repair who can offer any advice?
I plan to remove the carpet tonight to dry out properly, and I've read previous posts about how to check and clear the water hoses for blockages.
Cheers,
Craig.