@StillPaisleyCat I appreciate the long, well-thought out reply. But I'm not convinced. Lower Decks has a black woman, Tawny Newsome, first on the call sheet and Mike McMahan has said (IIRC) that by default all of the characters in the show are bisexual (something that's been shown in various ways on-screen), so I don't think you can point to Prodigy's cancellation due to some bias against LGBTQIA+, women or people of colour when you have a counterfactual right there in its sister show. In fact, every modern Trek show has its diversity boxes well and truly checked, but nobody is accusing Paramount of cancelling Picard because of some network executive's bias against an interacial lesbian relationship in Raffi/Seven.
I haven't watched any of the Yellowstone shows (they're on my list) but I understand that franchise has Kevin Costner, Harrison Ford and Helen Mirren in its stable. A show starring these actors is just going to do better than a show starring Kate Mulgrew (who's last-billed, albeit with the "and" credit), just as a show starring Patrick Stewart as the lead is inherently going to do better numbers than a show where Kate Mulgrew is a supporting character. Bring in, oh say Beyonce, as a lead on a Trek and I'm pretty sure the ratings will spike through the roof. It's not because they're white or male, it's because they're more famous.
They wouldn’t have done this with Picard or Kirk.
Maybe, maybe not. But if not, it's because Picard and Kirk are more iconic, more well recognised characters than Janeway. Star Trek was never more popular in the mainstream than in the mid 80s-early 90s, with the TOS movies and TNG TV series both in full flight. VOY ran during the Berman era's middle-age as Trek's star (nyuk nyuk) was beginning to fade. Fans know who Janeway is, but most people on the street wouldn't, whereas most people on the street would recognise Captain Kirk and the bald English guy from that space show.
By the way, I say all this as someone who thinks that Prodigy is a far more worthy addition to the franchise than the fan-lauded season 3 of Picard.