I'm sympathetic to people losing their nerve. It's a human reaction and can happen to anyone. But no way should he be allowed to keep his job after he's shown how unfit for it he is.
And the fact that the other cops didn't raise a peep over it tells me that most cops are in fact not heroes. Heroes do the right thing even when it's hard, you see. That's not an insult. I would like a society where policing doesn't have to be heroic. It's just a statement of fact.