How do I get over this pain and confusion and embarrassment?

You feel embarrassed because you he didn't respond to you the way you thought he would. Maybe he was turned off by your taking so long answering his messages. If he rather get drunk than meet up with you then feel lucky things haven't worked out like you hoped. You felt your relationship would go somewhere so you needn't feel to embarrassed about it. Taking chances is a part of life.