At least you got to go, and have a good time!
Plus he remembered at some point that he really did have work.
It may not have been what you had hoped... But you did get some good out of it, and that's worth it, right?
Besides, this might be a good lesson for him about responsibility.
Now that he's not drinking, he has a chance to actually learn from mistakes.