I'm really not at liberty to make that judgement call, but feel compelled to suggest letting his Dr be aware of the alcohol.
Your husband 'may' be resentful about that, but the Drs REALLY need to be aware of it.
Your husband needs alot of support and HOPE. He needs to have a support system in helping him 'change gears' in how he is approaching his condition.
Right now, it's obvious he is 'numbing' himself to not feel the pain.
The pain is absolutely horrible........he needs to be in the hands of a doctor that understands PN, like the others here have stressed

You are getting some VERY good advice from everyone here....

My prayer is that your husband will open up to receiving the proper care and realise what a wonderful wife he has fighting for his life!