Hi, and welcome!
He sounds a lot like my alcoholic husband #2 (the first one was sober when I married him and never went back to drinking). I married #2 during a brief period of sobriety (after nursing him through a horrendous episode of liver and kidney failure) because I thought he'd finally "got it". He didn't.
When I was married to #2 my two young sons from my first marriage loved him and felt sad when I left him. Today, fifteen years later, they still speak fondly of him, but they understand why I had to leave. He, too, was a lovely, nice, fun guy when he was sober, but he could be angry, harsh, and hypercritical when he was drinking.
Stick around, you will find lots of support here. I also cannot recommend Al-Anon highly enough. It was my lifeline to sanity when things got too crazy, and helped me stay strong until I was satisfied in my heart that it was time to leave.