This is the main reason for my post. Both Aurora and Odyssey are not common ships, they both play similarly as a flagship, but Odyssey is actually worth it and it doesn't even slow down your fleet. Fury still has a place as an early game flagship tho, 9 burn, cheap, easy to get. Aurora is basically an elite version of the Fury, but made lame in comparison to Odyssey which is a straight-up upgrade.
I think the one sentiment that is repeatedly echoed is that, by the time you get the Aurora, it's functionally outclassed by something else (Odyssey, Ziggurat, or any capital class) given its DP.
Maybe the issue isn't so much with the ship's stats, but rather is the ship's rarity. Aurora is an elite, player-piloted 8-burn ship that absolutely clobbers every other cruiser and lower class ship. But most other capital ships also does that. By the time you get the Aurora, there's already a lot of better options for killing cruisers/destroyers/frigates so the Aurora becomes a kind of rarely used ship.
I think a solution might be just to make the ship more accessible early on when fleet battles are smaller and the Aurora can be very powerful. Maybe make the Aurora a rare derelict drop from some quests or something like that so players can reliably get one into their fleet early.