For me, things got better when I began to accept what I could change and what I could not. When I figured out a plan that did not depend on anyone else doing what I wished they would do--what made sense for them to do, if they weren't in the grip of an addiction.
Obviously it would be ideal if he would stop drinking, enter recovery, and recommit to being a fully-participating member of the family. But there are no magic words or actions you can take to MAKE him do any of that.
What you can do is figure out what is best for you, and for your children, who don't get a say in managing their own lives, and just keep doing the next right thing towards that end--without depending on him to figure out his drinking. Right now what he is saying sounds hopeful, but when it comes to addiction, the only thing that matters is what he actually DOES.