Looks like the hose treatment is a good idea.
I would suggest just watering the tail gate door area on the roof first as water seeps around the door seal, my old truck did this, but the water made the boot area damp & not the rear seating area.
My sunroof leaked a little on my new truck in heavy...