I think it's important to accept that this is one of those situations (like most situations really!), where there is no one true way, no cut and dried absolutes.
When I came to my turning point, one of the first things DH did was get my support for getting rid of any alcohol in the house. Within 20 minutes, and before I'd set food out the bedroom, it was gone!
Secondly, without me asking or requiring, he just didn't drink alcohol for quite some time. It wasn't a big deal for him, and he didn't make it one.
But, I sincerely enjoy him unwinding with a glass of wine at the end of the day. It doesn't make me feel deprived, or resentful. I'm just grateful that he held on so long throughout my destructive life with alcohol, supported me in my journey (sorry, but it was!) to become sober, and we can enjoy life together today, him with his glass of red, me with my glass of zero alcohol rose.
I don't need his help to stay sober. Staying sober is on me, and me alone.
But as I say, it's different for everyone, and everyone's circumstances are unique to them.