My guess is the officer was just trying to jokingly do the “respect my authoritie” bit and had an AD.
First rule of weapons “don’t point it at anything you are not about to kill.”
He failed badly.
He needs to lose his right to possess a weapon period.
There is no such thing as an “accidental discharge”. He may claim negligent discharge, but based on the details, he deliberately discharged his weapon.
He behaved foolishly, criminally and unprofessionally.
Were he not a government employee, he likely would have received his termination papers months ago.