Re: How do I make things right with him after acting so stupid!
Since he was so luke warm to your idea of being in a proper relationship, it very well could be that he wanted out, and unfortunately you provided him with the perfect excuse by getting drunk and acting inappropriately. You didn't say specifically, but I'm guessing you pressured him to make a commitment to you, why can't we be together, why don't you just want to be with me, etc?
I think the worst thing you can do is hound him and beg forgiveness. Leave it for a few days, maybe even a week, and if you don't hear from him, just leave him a message saying you respect his decision and that you're sorry for behaving the way you did, and leave it at that. You can't change his mind for him, this is something he must decide for himself, and if he decides not to overlook this, or if he had already decided you were moving too fast for him and he wasn't prepared to give you what you wanted from him, then you have no choice but to accept it and move on, learning the lesson that you can't pressure a man into loving you or wanting to commit to you, and getting drunk when you are feeling emotionally vunerable and needy is ALWAYS a BIG mistake.