I can see two different things to work upon with two different people. One is the oblivious issue of alcohol. Another is your problem of stress. Even if let's consider for time being your husbands behaviour is not under your control but you can definitely take support for your stress. You can help yourself by managing thoughts with support of a psychologist. As of your husband he need a psychologist who can work with him on motivational interviewing it's a technique where in you make the client feel motivated to work on his problems. As in your husbands case everything that people see is going fine but he is not realising the consequences of future. But this process is an exercise and not just a chat. So see a psychologist expert in motivational interviewing and accordingly follow the treatment.
Next Steps
Take support for your stress which is under your control. See a psychologist for your husband who can help him motivate to work on this issue.
Health Tips
Be a support as alcoholism has deep roots and parental Schemas and need very high level of family support during and after the therapy or de-addiction treatment. Also ensure he goes to follow up meetings and support groups after his treatment is done.