Funny, I hadn't even noticed the lack of male officers in the Federation. I work in a place where my boss, her boss, her boss, and her boss the Executive Officer are all women. Some workplaces are like that. It has nothing to do with tokenism. Women and LGBTQ+ people exist in real life, and writers including these kinds of characters has nothing to do with "SJW identity politics". Again, the word you're looking for is tokenism, except it's not that. If you don't like entertainment writers including characters that exist in real life and have traditionally been underrepresented, I think you're in the wrong franchise. Or maybe you think it's pathetic that Gene Rodenberry wanted to have a multicultural crew for the Enterprise.

Seven having a relationship with Bjayzl makes her bisexual, not a lesbian. But maybe she is a lesbian. Some people date people of the opposite sex because that's what they think what they're supposed to do, before they come out as gay. It doesn't invalidate their past relationships.

The one thing you're right on is the unnecessary Romulan sibling sexual tension.