Trevor,
Finish your film in SD. The gain you might get from HD is putting graphics on in a larger resolution.
Then spend time with compressor tweaking the parameters to get the best upscale you can. It will probably take at least overnight to render though. Maybe try 30 seconds of the film as a test first.
Make sure you the film on a external monitor to check for field order issues before you convert.
Peter