There are so many reasons for leaks
Pour some water into each drain hole and see if water exits at a decent trickle under the car.
That will show they are clear.
However, even when clear, the tube by now will be hard a possible brittle, they can leak at some point along the length of the drain tube.
If the water does not drain quickly enough, it can rise up under the inner sunroof seal and into the car that way.
Another problem is water coming in through the rear qtr window seal, it soaks into the material from the rear interior panels that goes over the window frame and wicks into the car along the panel, normally turning into mush.
Lift up the rear carpet , throw away the saturated sound proofing and keep the carpet up. dry it out.
In the mean time, why not get something like this
