Sean,
Don't beat yourself up, you've got a drinking problem - when you drink, all bets are off. I did that more times than I care to think about, and for me, willpower alone definitely was not enough. What happened last night is not evidence that you lack willpower, it is evidence that you need to consider other/additional approaches to your sobriety.
Good luck, you can do this!