Good luck to you. Both of my wife's parents were alcoholics, but functional. It is something terrible that can really destroy one's health. We are very careful with alcohol comsumption because of that.

You might look into a local chapter of Alanon as a way of finding support from people who have experienced what you are facing.

As MWD and many others suggest work on GAL (and improving your quality of life). Your comment about singing and dancing sounds like you understand the importance of saving yourself and making yourself happy. Ultimately, we all need to take responsibility for our own happiness.

That doesn't mean that you can't continue to offer your husband support or opportunities. Typically, one would expect that if he is drinking excessively, he will have some kind of crisis where he hits bottom and it sinks in that he needs to change his ways. At that point, you may be able to help him, if you so choose.

Good luck and take care of yourself. You can only change yourself and offer support for changes that your spouse initiates.