Like, Star Wars is explicitly drawing from WWII, with big ships acting more like aircraft carriers they have guns, but the narrative focus is on the fighters and bombersa ka the airforce.
Like, there isn't the distinction because both star destroyers and TIE fighters are spaceships, but one feels like a blue-water ship and one feels like a military aircraft.
And while Star Trek can't help draw on WWII because it was first started when WWII vets were working (I know one of the original series episodes draws a lot on the feel of submarine warfare) the focus is on the crew of the big ships, not the fighter pilots
And a lot of the 'we are explorers who might have to shoot if shit happens' is designed to harken back to the era of ocean-going sailing ships, with attempts to do less imperialism.
Which mostly got me thinking about what sorts of SF technologies would you have to use to get other eras of 'doing things with ships', and that I don't know enough naval history to be useful.
I think someone on Quora asked a Star Trek question ('basically, which missions would Voyager be better on than Defiant') and my answer got me thinking about how Starfleet does military stuff, hence podnering this.
There you go! Star Trek Generations even opened the modern segment with the crew in costume on a Napoleonic sailing ship for Worf's promotion, and then getting called to the bridge still in archaic uniforms to go do a space rescue.
(I did a stint at an Archive that that a ton of shit from Gene Coon), and they often referenced the then current korean war of how officers should behave.
they have guns, but the narrative focus is on the fighters and bombersa ka the airforce.