@MLClark DS9 did the Bell Riots -- which is coming up September 1, 2024. Ironic, because San Francisco has a significant homeless problem right now.
In general, though, I think the Trek universe writes off those inconsistences as alternate timelines.
The TNG mirror-universe novel I posited established that the mirror universe occurred in the timeline where Edith Keeler did not die.
@MLClark As for mixed work environments ...
When I was a police dispatcher in the 1980s, any time we had a family dispute or any other potential for violence I always tried to send at least one female officer (of which we had few). Male officers tended to resolve conflicts with a show of power. Female officers tended to reason the situation. Also, men won't hit a woman but they'll hit a man, so bullies tended to back down.