Husband with alcohol problem

I've made several posts about this topic and I feel like on here I can vent, get sound feedback, and not be judged. Last night I hit my breaking point. My husband went out to a bar with his friend; I was fine with that, he came home around 1am and communicated perfectly. When he comes in, I see he doesn't look good. He looks sick. He lays on our bedroom floor, crawls to our bathroom, then throws up in our trashcan. I take care of him; get him water, Gatorade, throw out the trash bag and give him mouthwash. I decided this morning to talk to him. He tells me he had 7 beers in 2.5 hours last night, drove home (supposedly fine), and had 2 beers before leaving for the bar at our home, so 9 beers total. I told him that his drinking made him sick. He swears something else made him sick. He apologized and said he would drink less in social situations. What upsets me, is that every time he goes out with a friend socially he comes home drunk. At home he doesn't drink much but in social settings he's the life of the party. I don't know what to do anymore. I've contemplated leaving. We are in couples therapy. He swears he doesn't have a drinking problem and when I talk to him about it he becomes upset. I'm starting to believe that his drinking will destroy our marriage. I'm at the point where I'm even unsure if anything will fix it at this point. It'll be one year May 16 2021.