I sympathise with you, OP. I honestly do.
I started a thread not so long ago asking for advice on how to deal with a functional alcoholic. Many people advised to leave, but the problem is, a lot like the situation with your husband, my DH is not agressive, or abusive or violent. But he can be nasty if we ever have a argument when he's really drunk.
We haven't gone anywhere sinister either, the furthest we have been is pushing each other, at most twice, which is not great, but it's never escalated to hitting or anything of the sort.
I think your DH is a functional alcoholic, and that's really hard to deal with as drinking heavily in this country is seen as normal by most people. So if he doesn't see his problem, nobody else from outside will point it out to him. Only you know how awful it can be living with someone who drinks too much, and binges regularly.
My DH has made a fool of himself at weddings (though not socially on a regular basis), and I've gotten so angry with him I wanted to leave him straight away. But I'm still here. We have good moments too together during the day as his drinking is mainly late in the evenings, when I'm asleep anyway, or doing my own stuff. I try not to monitor his drinking, as that drives me insane.
If he's getting drunk on purpose, to embarrass you and humilate you, that's more to do with being just nasty or vindictive, and the alcohol is not fully to blame. But alcohol always makes things worse, rarely better, in my experience.
I was recommended this book and I'm reading it at the moment.
this book
There are no easy answers for this sort of scenario, but if the children are old enough to understand, and there is no happiness for long periods of time, maybe it is time to live separate lives.
Even though I love my DH, I know that when the DC's are old enough and I keep getting regularly angry about his drinking, that I would consider living apart. Maybe still in a relationship, but not together under the same roof.
Good luck!