From what I have read, what's happening in SF is reflective of what's happening right across US. Encampments of drug addicted homeless people with authorities at a loss of what to do. From what I understand, this isn't just a SF problem but a nationwide epidemic of drug dependency. But as a non SF resident, of course defer to local knowledge

Chesa prosecuted more people than the previous DA nobody was offended by. The police just didn't like him so they stopped enforcing all the laws.

He did offend the Asian community with insensitive comments on attacks on them, which might've been enough for a recall.

Chesa Boudin, the previous DA, was ousted in large part due to his prosecuting rogue police officers. His progressive policies and interest in restorative justice made him an extra easy target. The issues of crime and homelessness in San Francisco predate Boudin, and while current DA has a much more cozy relationship with the police (she disbanded the group investigating/prosecuting police misconduct) the crime trajectory hasn't changed.