I was able to fix the passenger side lower drain tube last night. It was actually pretty easy and here'* how I did it.

1. I pulled out the nipple and lower tube through the wheel well and set that aside.
2. I then fed a string into the body cavity from the inside of the car.
3. I used a coat hanger with a hook bent onto the end to fish the string from the cavity through the hole in the wheel well where the tube drains out.
4. I tied the string to the end of the lower drain tube and inserted it back into the hole in the wheel well.
5. I went back into the car and pulled the string out through the body cavity and the tube came with it.
6. I secured the upper and lower tubes together with a zip tie and the water drains out of the car again!

The process was similar to running wire up a wall in your home and easy too! It only took a few minutes.

Glad to hear it was that easy. I was not able to access the area where the upper was joined to the lower, so I had to do it the way I described.