eh, you might want to broaden your horizons a bit:
If you want to really go deep into sci-fi, there's a bunch of military sci-fi series out there that have never made it to video in any fashion, despite deserving it.
The Honorverse basically starts off as Napoleonic Wars in space, with Honor standing in for Hortaio Hornblower, though it does eventually introduce carriers(and yes, there is legit technical reasons fighters didn't work in this universe, due to quirks of their spacedrive technology that also informed how their ships are designed and armed, and apart from one particular twist regarding gravity technology, they play fair with Newton and our physics.)
The Bolos are essentially supertanks with AGI, made to protect man throughout many wars. there's a whole history I can't get into here, and MANY authors have played in this universe in the various collections.
I'm not too familiar with this saga, but I've seen it recommended multiple times. It revolves around a mercenary company in a sci-fi universe, is all I can recall at the moment.
Like the Bolo books, another situation where a bunch of authors come to play in one author's world - in this case Larry Niven's Known Space universe. These all revolve around the warlike Kzinti and their interstellar wars with the newly expanding humans(and typically getting their tails kicked back to Kzin due to how inventive humans are with their lesser tech)
And that's just a few I'm aware of off the top of my head. (Also I highly recommend the Honorverse books if you want to see how an actual space navy might run things)