The hose is exactly long enough to reach the bottom of the A piller cavity, gave it a little tug and it's not going anywhere, it's not ripped or deteriorating so I don't think it broke off.

I'm guessing it was supposed to be secured in the foam blob and wasn't and I've just never had enough water in the sunroof to notice? I stuffed my hand in there and felt all around and there isn't anywhere it could have been pulled out of.