Have any guys here ever had an excellent first date and then horribly messed up a second date beyond repair?

So long story short this happened a few years ago. Met this lovely girl and it went surprisingly well. We hit up a few bars and were kissing etc. She then text me saying shed love to see me again after the date was over.

Get to the second date I took her to a different place and I was very uncomfortable for some reason. Struggled to maintain conversation and felt overall completely unconfident and went into it with a negative mindset (id already lost before the date had even started).

Without giving too much away someone said something to us and didn’t even feel confident in defending her.

All ended in an awkward kiss and unmatch on okcupid immediately after the date so I knew it was over.

Im a high functioning Asperger’s and I think it slipped through that time as I am socially awkward to a degree.

I wanted to know if any of you had a similar experience? In that you can literally go from 100 to 0 just like that as I cant seem to find anything on google of this happening.

This did initially reassure me as it gave me confidence that it can be done but no I cant stop thinking about the ‘what ifs?’

I am now 28 and yet to have a girlfriend and getting nervous I won’t get one.

Not been on a date since as was just prior to lockdown.

Sorry for the long post been a lot on my mind lately.