I do not know whether such things work, maybe sometimes. I doubt it would have worked on me, but I am not very fond of loosing control in general – except for intoxication.
If I were in your situation I would probably think hard on where my boundaries are and be firm on them. “This is what I can accept and if we can not agree on that, then there is not much future in this.”
I do not know what motivates your husband to drink, he does not sound to be a go happy drinker that just likes to party – it does more sound as escapism to some degree. I am not sure people always want to give it up – or even can.