I am glad this did not end up any worse. I give you HUGE credit for calling his ex-wife. God truly works, that's a very hard thing for a codie to do. This is a great example of what happens when accountability is not usurped from the alcoholic to the codependent. Leaving the house a mess, alerting the ex-wife, stating that you will not put up with the behavior anymore. Had you not, today he would be drunk in a house cleaned by you possibly with his kids. This is a perfect example of how co-dependency and enabling perpetuates alcoholism, and how stopping that behavior helps, not hurts, the alcoholic.
I hope that while he is gone that you will start working on your own recovery. (((hugs)))