The cop that pulled the trigger will have to live with it for the rest of his/her life.
Like all people, most cops are decent people. To assume otherwise is just wrong.
I personally know several cops. They are without exception excellent human beings. They work hard, with little pay, to serve the public.