The officer (Philip Brailsford) is still fired because he broke police department policy by having "you're f***ed" custom engraved into his rifle dust cover.
The deceased also said (on video) that he *wasn’t* inebriated.
And yes, he did indeed deserve to be fired for that among other reasons.