A lot can change when we get sober. You cannot get your wife sober, as already stated but working on yourself and forging a new road, a healthier road, will only produce positive results.
As for the sex: I dont know about this one but I do think it is good that you are sharing and maybe someone will chime in with their experience on the subject.
Keep moving forward.