If this was a one off for him, i.e. he generally co-parents and does his fair share of mornings and night time stuff, and isn't regularly out to the point of hangovers, I think you are massively unreasonable.
Everyone should be allowed a social life (I hope he gives you chance to go out, albeit obviously not drinking at the moment!) and everyone is allowed the occasional off day even if it is self-inflicted.
I know you are having a rough time, but you should have cut him some slack after his leaving do. And I'm sorry, "weaponizing the kids" does sound like an accurate description, them charging in to see him sounds like a situation you engineered for the chance to either inflict further pain on him, or to access the "your father doesn't want to see you" type lines. The language is dreadful, I'll give you that, but if the guy is usually a good father and husband who is having a one-off off day, I can understand his frustration. The water is surface level quite comedic, but I hope that he stores it up and does the same to you if you one day have a hangover, and I trust you wont cry "abuse!" if he reciprocates.
So, if this is a one-off or rare occurrence, and he's otherwise playing his part, well, this fishwife stuff is why many men call it a day.
If he's regularly pissed up and leaves everything to you, well that's very different.