I would really recommend that you not try to stick something down through the drain. You will either push the tube off of the sunroof tray, which will require dropping the headliner to reattach or you will put a hole in the elbow that attaches the drain tube to the inner fender wall.
The mostly likely cause of water in the footwell is the failure of the drain tube elbow. If the sunroof drain is clogged, the water will be in the headliner. Is there water dripping from the interior light fixture? if not, then the sunroof drain is fine, the carpet is getting wet because the drain tube no longer exits out the fender wall.
Do this first:
1. Remove the A pillar trim; pop off the "air bag" cap, remove bolt, pull off trim. With the trim removed, you can see the drain tube. It's black, about 3/8" in diameter.
2. Remove the trim panel under the dash, this is the panel that closes the area above the pedals. There are two weird screws that take about one turn to loosen, an interior trim clip and wiring to the footwell light.
3. Remove the rest/dead pedal; lift the foot pad off of the left rest pedal, loosen two nuts with a 10mm socket and extension, remove the foot rest.
4. Remove the handle for the hood release
5. Remove the kick panel,
6. Move the seat all the way back and look up the side of the foot well toward the A pillar. If needed have someone shake the drain tube to make it more visible . Amongst all the wiring, you will see how the drain tube attaches to a rubber elbow that in turn, should attache to the inner fender well. Mostly likely, its just dangling there.
You will likely see that the rubber elbow is no longer attached to the fender wall, This is where the water is coming from. You will need to buy a new drain tube just to get the rubber elbow. You can slip the old one off and replace with new. DON'T pull on the drain tube, you might pull it off of the sunroof try and than you will have a really big job.
To dry the carpet, lift the door threshold and lift the carpet. You can slip a shop vac nozzle in there and get some of the water. Most of it is soaked into your carpet. I put dry towels under the carpet squeezed out the rest. Drying the carpet is a knuckle busting job that will really make you want to fix that leak.