One consequence of drinking is you don't get to have sex with your wife. She thinks you are gross or she doesn't feel close to you.
Sleeping with him when you don't want to would be enabling him.
I remember my alkie whining about how he wasn't getting enough sex. Oh boo-hoo.
He can fix this though: he can get sober and rebuild the relationship he damaged. And then maybe his wife will want sex with him again.