Knowing that not drinking around the kids is outlined in the agreement, how you order a draft "without thinking"? I assume the agreement was drafted as written because he has alcohol problems, and I don't see an immediate way out of this one based on what you've written. I assume the previous allegations were dismissed because they were based on what the children told the ex, and the ex's testimony would be hearsay. Sounds like there is more evidence this time. He should hire a family law attorney immediately.
The contents of this answer should be considered friendly advice, not legal advice (I'm a pretty friendly guy), and the answer should not be construed to constitute an attorney-client relationship. If you'd like actual legal advice, call me for a free consultation at 813-635-0222. Also, if you liked this answer as much as my big ego thinks you did, be sure to click the thumbs-up button!
Is there a motion for contempt pending against him at this time for drinking the draft beer? If so, I agree with Mr. Rose, he would need to take his final judgment copy and copies of any contempt order(s) he has had entered against him before and have an in person consultation with a lawyer of his choice to see if he can obtain his/her representation. The outcome will depend on the language of the motion, the judge, the facts, and the presentation of the case. It appears there is much more from what you reflect about your granddaughter taking photographs around the house.
Alejandro R. Lopez, Esq.
Law Office of Alejandro R. Lopez, P.A.
4465 Edgewater Dr.,
Orlando, Fla. 32804