Hi again, its my first time growing pumpkins too and I'm really hoping to get it right so I understand your concern. I've done a ton of research and I'd love to help you if I can. As I said before, I would definitely get your vine back on the ground and be sure that it has contact with nice, healthy soil to reroot.
I know watching the female flowers die off can be upsetting but often pumpkin growers pull off the female flowers until the vine is very sturdy and 8-10 feet long to ensure larger pumpkins so it might not be a bad thing (I used to hate watching my lemon tree drop fruit but really it is just the plant doing what it needs to do to produce great fruit!)
Anyhow, would you mind telling me, how long are the vines on your pumpkin plants?