Yes indeedy, got you covered.
Remove the rear panels by the back window. They have push on type fasteners, like you see on door trim panels. Give them a good pull. The white fasteners might be stuck into your roof, just pry them out gently and pop them back into the trim panel.
Next, remove the holy sh*t handle and interior light. It'* a bit tough, but remove the lamp lense first with a small screw driver. Next, try to find a release tab for the handle with your small screw driver. If you push on the tab, and pull on the handle, the assembly should come loose. You need to give it a good yank!
The handle with hang there by the wires. This is okay, it will give you enough room.
Now, pull on the rear center of the head liner. It'* velcroed to the roof. You'll hear the velcro coming loose.
Now, it'll be held in on both sides from the weather stripping around the rear doors. Gently coax the head liner from the channel of the weather stripping.
The rear of it should drop now far enough for you to stick your beak in and see what'* going on.
You don't have to fully remove the head liner. You can manipulate it enough to gain access to the tubes.
The hoses are black rubber. They push onto the drain port from the sunroof. Grab yourself some small gear clamps to fasten them back to the drains. They'll think twice of coming off now!
My fronts were okay, so I would imagine if you wanted to drop it further, you would need to remove the trim around the sunroof, then remove the A pillar trim panels.
Pull up your carpet, and let it dry. If you have time to take the seats out, and all of the carpet to let it dry in the sun, that would be best. Otherwise, at least replace the rear under padding, put the carpet back down, go to your nearest car wash, and use their high suction vaccuum to remove the majority of the water.
Once you have completed your tasks, open the sunroof, and pour a measuring cup of water into the channels. The rear tubes drain by the rear wheels, the front tubes by the front wheels. I had to jack my car up to coax the water into the rear drain.
You don't want to go through all this and find out one is blocked!
If it is blocked, use low pressure air and blow the tubes out, or use a long wire and poke your way throught the obstruction.
Judging by what you have shared, I'll bet one, if not more are disconnected, this is why I didn't suggest checking for blocks in the tubes first!!
Drop me a line if you have any more questions. This was quite a project, but rewarding once completed. My car is nice and dry, and quiter from repairing the weather stripping and the better under pad.
Oh: and check this out: