Yellow,
Alcoholism is truly a family disease and does not just affect the alcoholic.
The 3cs re alcoholism:-
You did not cause it
You cannot control it
You cannot cure it
Again that word "adore" re the children; your children do not adore their dad so much as are afraid of him. Stop using that word right now with reference to your children, they are afraid of him and are becoming super responsible for him as well (one of many damaging effects of being with an alcoholic parent).
What do you get out of this relationship now?.
Did you grow up yourself in a household where parents or other family relations drank heavily? What made you choose this man as a DH?.
He likely has had a drink problem of many years standing.
You are with an alcoholic and you are lurching from crisis to crisis. This is what life is like with such people; its no life at all for you and your children. This man's primary relationship is with drink; its not with you or your children. His thoughts centre on where the next drink is going to come from.
You are also playing out the roles associated with partners of alcoholics; i.e. provoker (you never forget) and enabler. You work and use him as childcare; that now has to change. You also left him drunk in charge of your children at a football match due to your own shame and embarrassment at being in that situation at all.
Do not cover up or excuse him any more; start opening up to other people. Alcoholism as well thrives on secrecy.
I would also look carefully at your future within this because currently you and your children are being dragged down with him. What do you want to teach them about relationships, surely not the shite role model of one. They are already wanting to look after him and they are being damaged by seeing their drunkard dad. They run a real risk of becoming alcoholics as well or choosing an alcoholic partner, that could all too easily happen if you choose to stay because they will learn to normalise all this. You cannot protect them from his alcoholism and its effects; you're profoundly affected by his drinking too.
Your own recovery from his alcoholism will only properly start when you have fully extricated your own self from the situation whilst addressing your own role in it. Co-dependency often features in these types of marriages all too frequently.
E-mailing him etc will be a waste of time because all he will hear from you is white noise. It is no point in talking to him now, you can only help your own self here and you need to divorce this man. This man could also lose everything and everyone around him and he could still choose to drink afterwards. You cannot control what he does or will do.
You need to get yourself and your children out of this relationship, there is nothing to rescue and or save here. Seek legal advice re your own situation and also get support from Al-anon. Womens Aid can also help you here; their number is 0808 2000 247.