Thanks for the advice. I ended up solving this a while ago when the post was originally made, but for future reference, here is what worked for me:
I blew compressed air in but it didn’t clear all of it, the leak was back a little but later and not much changed. I ended up getting a wire coat hanger, untwisted it, and snaked it down the front A pillar piper and twisted it around and got a ton of sand, mud, and dirt to come out. No leaks after that or problems, well, until an inattentive driver T-boned me. Now I’m over on the Impreza side of things, with no sunroof to leak