If he has gone 30 plus days since his last drink, any physical side-effects would be over by now. Psychological side effects are a different matter. If he is not in any kind of support program, the chances of him not picking up again are quite small. Even if he doesn't drink, he is still not in recovery. Recovery consists of not only not drinking, but addressing other issues as well. The non-existent sex life is definitely one of those issues, as is irritability, isolation, depression, restlessness, etc.
You might wish to attend al-anon meetings in order to have your own support.