We all DNF at some point in our lives. It's nothing to be ashamed or be upset at yourself. Things like this happen more times than not.

Lot of qudos for riding as long as you did with all the aches and pain. When you get over your aches and pain, I think you'll find yourself to be lot stronger and have lot more endurance than before the ride.

keep riding and enjoy your rides.