I do know of at least two massive school shootings - Parkland and Uvalde - where the cops literally cowered outside, and listened as the shooter murdered child after child.

Every cop is trained that their primary objective is to make it home safe at the end of shift. Anything they have to do to accomplish that is acceptable, including killing people or allowing people to be killed. Cops don't protect anyone but themselves.