What, pray tell, were you supposed to apologize FOR? Getting sick? What does he think, you enjoyed puking all night and did it just to annoy him?
I totally do not get why you should apologize. I also do not get why he threw a fit and slept on the couch the next night. What exactly is his problem? You were at home, your friends had already left. Your husband sounds like a giant spaz.
As for the drinking thing, do you drink very often? It could be that your tolerance is way down. Back in the day I was throwing back an average of four beers and three shots a night. (Ah, squandered youth). I stopped drinking at the beginning of the year, but thought I could still tie one on for special occassions. However, even a single shot will leave me feeling hungover and sick, so I've just given up the whole thing up altogether.
I keep thinking there has to be something more to the story here, is your husband really just mad because you threw up? That sounds extremely irrational.