You've got a history of abusive relationships; was your parents' relationship poor, or were you treated poorly as a child? It often happens that if that's the example we grew up with, poor treatment within a relationship seems normal, or even good, to us, when it's actually abusive. We have trouble listening to our gut instinct, suffer from cognitive dissonance, and try endlessly and unsuccessfully to manipulate our partners into better behaviour, because leaving was not demonstrated to us as an option.
After an emotionally abusive relationship with my children’s father, my partner is amazing
This looks a lot to me like 'My partner does not abuse me anything like as badly as my previous partner, and I don't actually know what a healthy relationship looks like.'
I'm sorry, but if your partner really was amazing, you wouldn't be feeling the need to post on an internet forum about how to deal with him being an angry drunk. That's simply not what amazing partners do. If he wants help, he has to take responsibility for seeking it out. Until he does this of his own accord, he will not be taking responsibility for his issues in any sense.
You need to look after your own health, and the welfare of your children. Set some boundaries. Work out what's acceptable to you and what is not. Tell him that if he disrespects your boundaries, you will leave. Let him decide what's more important to him: you or the bottle. Follow through if he lets you down.
I'm sorry, this can't be easy to read.