You're looking for validation, it seems. I wasn't there, but perhaps it would have been better to point out your seniority in the car in light of his admission, and say it's best he takes a sickie to avoid you having to report him out of duty, and to stay sober for work in future. Consider it a warning etc.
The mortgage and holiday are a bummer, especially in this climate. Then again he may have ignored you and killed or maimed someone. Who knows? If he'd not turned up drunk this would never have happened so ultimately he can only blame himself.