Police in Germany are now authorized to carry their sidearms off-duty. They may also get permission to carry another handgun that might be easier to conceal in civilian clothing.
Norwegian police officers are issued firearms. They are required to be kept in a locked container in the patrol car. In recent months, Norwegian police officers have requested to be allowed to carry their guns. Incidentally, police in Iceland are also issued firearms that are stored in their vehicles.
Squads of armed police have been increased in the U.K., New Zealand, and Australia. In Ireland, about 2,700 members of the roughly 12,500 non-command members of the Garda carry firearms.
You look at raw numbers and get upset. Have you actually examined the incidents in which lethal force was required? I doubt it for the simple reason that if you had looked at them, you wouldn't be spouting such nonsense.
Perhaps if California (and a lot of other states) hadn't crippled their mental health services so badly, there wouldn't be a need to send police. They are not trained to handle the calls but they have been dumped on them anyway.
There are probably some details you omitted from your account of the death of Edgar. Things like did Edgar act in a threatening manner? He was holding a kitchen knife: was he planning to chop vegetables or was he holding it like a weapon? Was there any time for officers to do anything but react to a threat?
These details might not be important to you, but I assure you, they are important. I am also fairly sure they were investigated by the department that employed the officers.
America is not like Germany. America is not like Great Britain, Ireland, or pretty much anywhere else.
Police work is not nice; police work is not pretty. Nobody calls the cops when everything is fine.
When the FBI was formed, agents were not armed. After a number of them were killed, the agents began carrying guns.
You should also be aware of something else: when the ability of police forces to respond were compromised, first by COVID-19 and then by widespread violence, people reacted. How did they react? By buying guns in record numbers. Over the past six months, an estimated five million Americans who previously did not own a gun became gun owners. Through the end of August, total gun sales had surpassed the total number of guns sold in all 12 months of 2019.
It's likely that there are well over 100 million gun owners in the United States. That's about four out of every ten American adults.
If you want to see fewer arrests for "mostly petty crimes," change the laws. The cops have nothing to do with it. The police officer's job is to enforce the laws, arrest those who violate them, and preserve civil order. There's nothing in the job description about making laws.