I think your husband creating a bit of accountability for you was a good thing, there are soo many posts on SR about spouses drinking in front of people or not taking things seriously, or spouses not even knowing about the problem.
Getting the kids involved could have been done a bit better, but I guess his heart was probably in the right place!!
Anyways, pick yourself up, and go at it again!! you'll get there!!