If alcohol impairment is reason to restrict operation of a motor vehicle it certainly should be reason to restrict the police power of an impaired individual. Public intoxication charges don't even require a degree of intoxication for conviction. Maybe police officers under the influence of alcohol or other drugs should not be allowed to have police powers. Unfortunately drunk police officers are rarely held accountable for their actions. For that matter officers are very rarely even required to submit to testing to determine their degree of impairment.
I agree with you, except this guy was retired. There was a recent story here in Los Angeles about cops on the beat, who spend more time eating donuts than working. Sounds like an old joke, but it's true, they were followed around by hidden cameras and seens lounging around different eateries for most of their shifts.
He was retired.