That's just my experience as well. There are many other types of ships like bombers with big explosive, slow shots with blast effect, and other ships that can have other players attach to them as turrets. If your team in the arena can escort a bomber safely to a base with some fighters, you can often nuke the enemy right through the walls and capture the flag there. Meanwhile if you are just piloting a fighter it's a big win to take out one of the turret ships. Then there's other ships like ones that can cloak and fire sneak attacks, etc..
Essentially: distill gameplay to a relatively small number of rules + iterate balance until it's incredibly finely tuned + let the playerbase go nuts with whatever strategies they can come up with.
The attraction being that they're easy to pick up (few rules to learn) but incredibly deep (complex interactions and strategies).
Coupled with the fact that circa-late-90s, the idea of an MMO was still mind blowing. Games with friends and strangers?!
From memory, SubSpace also had a fairly addictive loot mechanic (tiered materials, item construction, randomly timed rare enemy spawns).