OP, I am glad you are getting a few kinder posts.
Of course this is a shit show and you behaved badly, but him calling the police when there was no threatening behaviour would only have exacerbated the upset for your children.
As this is not a regular occurrence it will be the police being called that they will likely remember.
He was thoughtless and I think you have felt that he was off.
I 100% think he wanted out and he has manipulated this situation, calling the police so that he can exit on that basis.
Get your drinking sorted.
Definitely get some therapy.
Don't chase him.
I think he has had one foot out the door and took his chance.
He quite possibly was deliberate in his actions knowing that it would land.
This is obviously very painful for you, see your GP for support if you feel yourself sliding.
Your children need their mum well.
This will be a very confusing time for them.
I think your husband has been very selfish in his actions, blowing this up, even though you have to take full responsibility for the condition you came home in.
On the basis of you being absolutely no physical threat to anyone, a decent parent would de-escalate the situation as best they can, get the partner to bed and deal with it sober.
He could have done that and still left.
Accept it really is over and mind yourself as best you can.