Hi Op, I hope you're doing OK.
You said when this happened a year ago it was 'the final straw'. But it wasn't because you forgave him and agreed to stay together.
Now he's (literally) peed all over his promise to you, and peed all over your marriage by showing that he didn't mean his promises last year. It would be very easy to refuse alcohol (unless he has an addiction, in which case I'd leave him for that reason) but he chose to put having another drink over his wife and children.
That's because either:
- you really aren't that important to him
- he arrogantly thinks he can treat you badly and you'll always forgive him
- he isn't control of his drinking.
Whichever of those it is, you need to leave him. He's shown you that you can't trust his promises. He's shown you that he won't prioritise your marriage over drink. He's shown you that he isn't that mortified about what happened last year / many times in the past, and is happy to keep doing it.
He can be as 'mortified' as he likes today, but clearly he isn't really, or it wouldn't have ever happened again. If you forgive him, it will keep happening.
You were very clear a year ago - do it again and we're divorcing. If you stay with him now, you will just embed his idea that he can treat you like sh*t and you'll stick around. He'll be MORE likely to do it again. It will devalue you in his eyes.
If you split now - be clear with him that it's all on him. It was his choice. You had a clear agreement and he's the one who chose to divorce by going back on the agreement.
Aside from all of that, how could you possibly respect or be attracted to him anymore? No matter how (pretend) contrite he is, or even if he somehow managed to never do it again (he won't) why would you want to stay with someone so repulsive?