He was drunk, thus, he hopped in the wrong car. This is good, one less drunk driver on the road.
Perhaps you can find someone in the neighborhood to drive your children to school. As for his AA meetings, he can take a bus or walk there. That is his problem.
Personally, I would not let him drive my children anywhere. He has only been sober for a few weeks, hardly long enough to entrust him with your children.
What about hiring a nanny? Have him get a job to pay for the nanny. Problem eliminated.