Not anymore - that expectation disappeared with the first DEI hire. They're clearly showing you that there's NO reason to expect a cop to know better. Expecting one to know better could get you shot in the leg and killed.
Justine Damond expected that a cop was trained and properly vetted, and paid for it with her life when DEI hire Mohamed Noor of the Minneapolis Police Department shot her.
https://en.wikipedia.org/wiki/Killing_of_Justine_Damond
I can not disagree with you on that comment, society indeed has lowered what should be the bare min expectations.