I agree that he probably wont be killed, and I sure do hope that none of his family are hurt, as that would be acting like the police.
But, at the very minimum, now police officers everywhere are going to be more on guard and thinking 3 times before doing something that will end a life (as they should have always been doing). He sure as hell isn't the first p.o.s cop that has killed a dog, and most likely wont be the last. However, I'm glad to see the support behind this, and as just mentioned, it will change the way police act as they know that someone may be recording, and if they fuck up, it could be their ass.
Oh, and I'm totally with you on not wanting to be a cop. I can understand people wanting to help others, but the police aren't those people anymore (if they ever were).