Honestly? Even if it's never gotten his bad before, his drinking has been an issue before and he hasn't stopped. The fact that he asked for sex tells me he isn't taking this seriously, and telling you what YOU should have done differently also tells me that he isn't all that sorry.
IF my husband did this (while drunk) he'd be in absolute tears. he wouldn't be telling me what to do differently or askign for sex, he'd be trying to prove he'd NEVER drink another drop ever.
I think that perhaps he thinks there are no consequences to his actions. *IF* he could honestly stop drinking all together, then maybe the relationship could go on IMO, but it seems like he's had issues drinking in the past and he hasn't stopped.