I agree with many of the others here. I wouldn't beat yourself up too much about this important lesson that you learned this weekend. It should help you to find a better way forward.
You are addicted to alcohol. As such, choosing to drink alcohol will take you down a road you don't want to go.
I never choose to drink alcohol and so I never have to go down that road. You can too!