You didn’t do anything wrong. You didn’t even embarrass yourself. This one just wasn’t for you. Next!
Do you find others attractive? When you want to go somewhere, like a movie, just ask someone to go with you.
I’ve found people to be really happy to get an invitation to do anything. They love when I ask them to lunch or whatever, even as a friend.
Maybe go to a single’s Meet Up. Just make friends with singles. Stay away from the unavailable.
This guy isn’t off the table as being your friend, either. Who knows, maybe he has a friend for you...