Hey, Pud. You'll get lots of responses with various things you can suggest to your husband so I'll leave that part to others.
I firmly believe that the expert on what your husband needs to get sober is... your husband. I'd suggest asking him rather than asking us. What he has to say is much more important than what we have to say. Others may disagree; that's just my opinion.
Of course you know that there's no way to make him get sober until he decides for himself that he's sick and tired of being sick and tired. Does he aspire to a better, happier, healthier life? He must, or he wouldn't have sought counseling. But obviously, the counseling was not effective and I don't see much point in repeating things which haven't worked.
I don't have much faith in confrontation or intervention because that definitely would not have worked for me. But others on here may have a different perspective.