Welcome to SR! Please stick around and read a lot. You will find that there are many people here who understand what you are dealing with.
Unfortunately, this scenario is quite common. It doesn't sound like your husband is interested in quitting drinking and asking an alcoholic to limit themselves to 3 or 4 beers just isn't going to work. As an adult, he has the right to drink if that's what he wants to do. But then, as an adult, you also have the right to decide what you will and will not tolerate. Continuing to threaten him with leaving and then not doing so just says to him that you are all talk and no walk. Only you can decide when you have had enough.