You'll have to get creative with your 'duct tape window handle'... and sometimes it helps to use some type of plastic (maybe an old credit card or something like that) to get it down far enough on the window to stick.
Your big problem will be: Why won't the window roll-up? From the looks of a 2005 Pilot Regulator, my guess is that the window won't stay up unless you do an ugly outside-tape-job to the roof.
The regulators are super easy to replace, it just requires time to take everything apart (door controls, door panels, weather seal plastic). There are lots of videos on youtube... and the cost of the regulator should be under $50.