Hello and welcome to JustAnswer!
If you're seeing water in the pillar then it has to be coming from the windshield or is sunroof related, depending on exactly where you're seeing it. If the windshield hasn't been replaced or removed for some reason then it's much more likely to be sunroof related.
It's possible that you could have a broken drain tube but it isn't very common. Broken drain tubes usually are only a problem in the winter when one gets plugged and then water freezes in the tube, expands and cracks it. It's very rare to have to replace a sunroof drain tube.
It's more likely that you have one or more plugged tubes. It's possible that the sunroof may not be closing correctly or has a damaged seal though, I'd start by making sure it's in good condition and closing correctly.
From there I'd water test the tubes. With the glass open you can pour water into the drain trough and watch how fast it drains or if it drains at all. If it doesn't drain then most often the debris can be cleared by carefully blowing through the tube with a blow gun.
Replacement of the tubes would be pretty time consuming and expensive since so much has to be taken apart to replace them, the headliner would have to come down and many trim panels removed. You' be looking at about a half day's worth of work to replace them all. having a shop clear the tubes if they're clogged though shouldn't exceed .5-1 hour of labor.
could you tell me when the tubes drain out of so that I can look for water coming out the other end. I believe I saw holds at all four corners of the sunroot. I will also take a look at the front windshield to see if it looks like it's seated properly.