I have been there myself. Loving husband abusing alcohol and taking cocaine. Disappearing. The come downs when he returns, the physical symptoms. They can be good at hiding their addictions and will lie and manipulate.
There is no comfort for us until your partner acknowledges he has a problem and seeks help. Only he can do this.
Emotions will not come into it, the coke sees to that I’m afraid and my heart goes out to you.
I hope he sees the light soon before its too late. All you can do is be there for him when he needs you so look after yourself and be strong.