Don't beat yourself up, you tried the best you could, even when your body said no, you tried. I can only imagine doing a 94 mile ride through the mountains or any other higher elevation. Just that alone is something to be proud of. And, along with that, to ride in that heat, wow. The heat will zap your energy, plus all of the initial energy you were putting into this trip is a heck of a lot. Maybe your body just wasn't ready. It's ok, just take this experience and use it to your advantage.