tl;dr, we need more time examples and research to say anything authoritative, but anecdotally things look very positive. One excerpt,
There have been no known major injuries of any community responder on the job so far, according to experts. And data suggests unarmed responders rarely need to call in police. In Eugene, Oregon, which has operated the Crisis Assistance Helping Out On The Streets (known locally as CAHOOTS) response team since 1989, roughly 1% of their calls end up requiring police backup, according to the organization. Albuquerque responders have asked for police in 1% of calls, as of January. In Denver, the Support Team Assisted Response (STAR) team had never called for police backup due to a safety issue as of July 2022, the most recent data available. In Durham, members of the Holistic Empathetic Assistance Response Team (HEART) reported feeling safe on 99% of calls.
Many communities are still sending alternative responders to a narrow subset of calls, and debating whether it’s safe to expand their scope. For example, many cities will only send community responders to situations that are outdoors or in public spaces. Programs are also divided on whether disputes between neighbors or within families are a proper place for crisis responders, or calls involving suicidal threats.
The more that police specialize in (and glorify) violent combat scenarios, the less useful and valuable they are to the public. We need trained responders.
I blame the backlash from 9/11. Before 2001, most cops saw themselves as police officers, Afterwards they all became anti-terrorism warriors.