Sorry to hear of your troubles.
What you will find here, is in most cases this problem is not going to fix itself. And you have very limited ability to effect a change.
You can try and tell him what you need. He might listen and change. Otherwise you have to learn to live with it or leave. There is no simple solution. There is no magic pill to take and it all gets better. Sorry.
Some use ultimatums. Others find they don't work. After 20+ years I gave my wife one, with our kids right there at the same time. And 8 months later our life is better. She is still drinking, just not much. She still lies and hides it. And I still debate leaving, as I know she can never stop.
Lots of experience here. So sit back and see what the subject matter experts say. Something someone says will click with you, and hopefully light the path for you.
Welcome.