Yup. It's common (sad to say.)
Your husband married a drinker - so he could take care of you, feel like the big man, etc.
You drastically changed the dynamic. Now he doesn't know what his role is. You changed the rules on him - you need to address this. You, not him.