There are also two lines to the rear.
The drain tubes aren't super skinny, so running something through them will only yield results if they are really full of debris, which has always seemed unlikely to me. The more important factor seems to be the tiny drain slits under the rocker panels, where the front tubes drain into. They are small and easily clogged, tubes get backed up, and the sunroof tray gets overwhelmed with water, thus finding its way onto the headliner. When I cleared the rocker drains while having the same issue, a bunch of dirty water came pouring out, and it hasn't happened again.
The rear hoses make a direct exit, so much less possibility of clogging
Of course, it's also possible your leak is due to something else, but the above is easy to check off. Also inspect the condition of the sunroof seal, and might as well take a look at the condition of your roof. Mine didn't appear bad at first glance (there was one lone rust spot) but upon further inspection I found some spider cracking in parts of the paint, went to redo that, and turns out I had a few pea-sized holes in the metal. That's since been repaired; still no issues.
I'm down in Juneau, so definitely know the struggle with precip!