It definitely changes the power dynamic in a relationship when a sloppy drunk becomes sober. This was the case for me. People aren't quite sure how to take you when they can't automatically distrust you and look down on you. I've heard many times that a spouse can feel uncomfortable when their partner get Sober because they are no longer the superior one way.
It's kind of like how morning people tend to look down on people who sleep in. I am the type that enjoys sleeping in on weekends. A few times when I've gotten up really early on a weekend my partner is kind of annoyed with me because he can no longer look down on me for sleeping in. Lol