Well done for having him leave.
You need the space to really think about what happened and why.
Please reach out for support.
Apologies mean nothing, actions are what count.
Take this time to reflect on his past behaviour.
Has their ever been a hint of controlling behaviour?
Ever a hint on anger, controlled rage, short temper, over reaction to small annoyances?
Because if there has been, this is very likely an escalation of this.
Tell your mid wife what happened.
Do you actually believe he will NEVER drink again?
Above all else your safety has to be paramount.
It is more important than how you feel.
This should change how you feel about him.
You now know what he is capable of and you need to think how that would effect how you will act around him.
I know if my husband behaved like that, it would make me very wary.
There would certainly never be any peace if he touched alcohol again.
Put yourself first here OP.
You deserve better than this.