Ends w/ a fizzle

So I spent most of this evening with a guy I met at work. (He comes in as a "client") We had a lil ice cream🍦 date and then he took me to a lil secluded mountain w/ an easy trail so we could walk to the top and look at the stars. All was well and romantic, it gets late, he takes me home, I decide to invite him in. We're just hanging out for a bit and then we start making out. Etc etc. 🙃

Anyways, he couldn't get his dick hard?? He was trying so hard and then I gently let him know that I think this was enough for tonight and he got the hint that I wanted him to leave. He took his sweet ass time leaving and the whole time he kept telling me how I look so good and he's so embarrassed and how he can't believe he fucked this up. He kept making comments that I was probably gonna block him as soon as he left and this was probably the last time he'll see me. 👀

So two things, first I just needed someone to tell bc most of my friends are in committed relationships or not into casual sex and so they don't like hearing about how I hoe around on occasion. 😶Second, has this happened to anyone else??? We didn't drink at all as he's sober and has been for a year so it's not whiskey dick. He didn't do anything strenuous today. I'm choosing to believe his words (you're so hot and pretty, I wanted this so bad) over what physically happened (his limp dick) but it's a lil hard bc i have insecurities anyways. I tried my best to not make him feel bad or embarrassed over it but is it super shitty of me to not want to see him again for fear this might happen again???

It just seems awkward af. I've been with 10 guys and this has never happened. 😭😭 if the sex was flat out bad then I opt not to see them again but idk if I should be more sensitive to this instance