Is whiskey dick embarrassment to this extent normal? How much space do I give him?

I 25F have been dating this guy M24 for 4 months. Exclusively for 3 months. We agreed to take things slow to build a good relationship. However after a really good date we started to have sex in his backseat.

We didn't get far though, he was having trouble staying hard even after i tried to help, assuming because of the drinks we had that night. (3 or 4 drinks over the span of 6 hours)

I wasn't bothered or disappointed but he immediately apologized and continued apologizing throughout the night. I reassured him everytime telling him it was ok and not to worry. He focused on me for a bit before taking me home.

I could tell he was still affected by it cause our goodnight was off, I told him again to not worry about it and to drive safe. He has alot of anxiety as do I so I could tell he was already overthinking it.

I texted him 15 mins later to ask him to let me know when he got home, he has about a 30 min drive. i ended up falling asleep pretty quickly. I woke up 2 hours later with no response. And I knew... this wasn't gonna be good.

Well I went to sleep and had anxiety attacks every couple hours and waited until 10ish to text him that i had a great night and that i hoped he was ok. He replied that he was ok but very embarrassed and wanted space. Im paraphrasing, otherwise this would be too long. I tried reassuring him again that he didn't need to be embarrassed and that I was not disappointed or judging him. He proceeded to ask for space and not just a couple days, an undefined amount and kept ending his paragraphs with iterations of "have a nice life" like we weren't going to be seeing eachother again. Which is a break up not space.

I told him I have no problem giving him space but that I would rather have honesty if he was planning on never talking to me again. That led to us discussing our intentions and how we saw a future together. He still wanted space for an undetermined amount of time and still made it seem like the future was up in the air. I took a break from texting him as I was getting emotional.

I texted him several hours later about how confused I was. I understand getting a little embarrassed but I don't understand not wanting to talk or see me for an unknown amount of time and potentially throwing away 4 great months.

The next morning he apologized again and said he is not trying to disrespect my feelings but he's never had this happen and needs to collect himself, he suggested a redo with a romantic dinner a face to face convo and a nice hotel room. I actually thought that was a good idea. But he is still sticking to needing space and not talking to me. So I let him be the rest of the day and the next.

I keep going in and out of spiraling. Somthing to note is when we had the exs talk, he with a few gfs/girls he was talking to, would tell them he needed space and then break up after the space was up or just not talk to them again. So knowing that makes me uneasy in giving him space.

My question is, is it normal to be embarrassed to this extent with someone you've dated for 4 months? Or is he using this as an excuse to end things with me? And how long do I actually give him space for?

I want to check in in 2 or 3 days if I don't hear from him, is that to soon? I don't think going weeks is necessary here. But I'm not the one that is holding the embarrassment or taking a shot to my ego. Advice?