It still happens
Not just snipers, but armed robbers, hostage takers, guy wanting to commit suicide by cop and taking a cop with him. Bomb squads can use an MRAP. There are times when a local police force needs access to an armored vehicle
If it saves one cops life, I am OK with it
So you want to wrap cops in SWAT gear and MRAPs to offset the occasional killing of a civilian police officer?
Occasionally a cop will be killed. Occasionally a construction worker will be killed. Occasionally a deep-sea fisherman will be killed, and on and on. The civilian police occupation is
not the most dangerous job of all but it does present some level of danger. Anyone who wants to be a cop must understand and accept that relative level of risk. Otherwise there are much safer jobs.
Civilian cops are not soldiers and it's time we stopped trying to transform them. Because we don't want soldiers patrolling our streets.