I avoid superstar because making my flagship punch a little above its normal power takes the most points, but the benefits I get back are relatively puny compared to other options. If I want the most powerful character, I do not take lame options.
If I spend everything into personal skills (and Loadout Design 3 and Electronic Warfare 1), my flagship can punch one or two classes above an unskilled ship. The rest of my fleet does not have the passive boosts like more CR (from Fleet Logistics 3) or better fighters (from Fighter Doctrine), and I have no campaign or QoL skills (no Navigation, no Surveying, no Salvaging). If I spend everything on my flagship only and give up fleetwide or campaign abilities, I better be able to solo everything like during 0.6.x or 0.7.x. But that is not possible. In 0.7, a battleship (especially Onslaught) could solo everything in the simulator (or even combined skilled fleets over 100+ ships in campaign) with peak performance to spare. Today, Paragon, the most powerful ship in the 0.8 game, with all of the best combat/personal skills, is unable to solo the simulator (which has 80-something ships) before running out of CR. Frigates with all of the combat skills have trouble soloing big ships, and destroyers might not be able to solo Paragon. This assumes the enemy is unskilled. If they have skills too, I probably simply breaking even with my flagship, while the rest of my fleet may be at a disadvantage (because I did not grab some of the fleetwide skills).
Also, another problem with personal skills that are highly specialized (like Carrier Command) is I may be married to a ship. If I want to be the best carrier pilot, I would be stuck with Astral. If I want to change ships, I have useless skills. I cannot respec.
Leadership has few skills that duplicate personal skills (in Combat and Leadership) except they apply to the whole fleet.
You can crush any enemy by running a fleet with four or so Paragons or a bunch of carriers, it's not hard to do and it has been a viable "crushing" option for many versions now. So why avoid playing the "superstar" now when overwhelming the enemy has been an option for so long?
With that much ship power, I do not need skills to kill the enemy. In 0.8, making my flagship only better at the cost of everything else does not make a significant difference strategically (i.e., skilled flagship performance alone is not significantly better than unskilled performance). Before 0.8, I could grab max combat skills and solo fleets that an unskilled ship cannot do.
Moreover, Herons and Drovers while very effective they cannot kill multiple cruisers in a short span of time by themselves and also take out frigates, especially if outnumbered. The Aurora can. It's a multipurpose ship which is why it shines on the hand of the player, allowing us to take the lead role of the fleet. The only type support that I do is when I do a full deploy I fly around making sure no single ship of my fleet is in a bad position, because ships like the Medusa, Aurora and the Falcon are fast and strong enough to allow for this. However, I never feel like I'm a "cheerleader" since I'm actually engaging in combat and also constantly flanking the enemy. It's fun and it feels like I'm actually leading my fleet.
I clicked your link, but I need to download it then view it in some app. No thanks.
I tried Aurora, and I have trouble killing multiple cruisers without either 1) Sabot spam (which is risky) or 2) getting Hardened Subsystems and outlasting them. Multiple cruisers simply ball up and make it hard to kill. Well, enemy Aurora is fairly easy to separate, but the rest simply blob up into a deathball and trying to kill them with terrible shot range (and terrible flux effienency) is very hard unless Aurora outlasts them in peak performance. At least Aurora can kite and stall. Others, except Heron, would probably get surrounded and killed.
Aurora is sufficiently expensive enough that I prefer to grab a capital (except Odyssey without any Tachyon Lances) to kill cruisers as well as capitals. I do not trust AI to pilot the Aurora either, especially when it is the easiest enemy cruiser to kill due to its relative recklessness. (Aurora tends to be less cowardly than the average ship.)
But the point of Heron and Drover is to counter fast enemies, so that I do not need to bring frigates (or Medusa). Against cruisers, I bring my Legion or Paragon. Cruisers are not fast enough to disengage from them. If I lack a capital, I use various cruiser-sized clunkers among Falcon, Eagle, Dominator, Heron, and Mora which are readily available, as well as the weapons they can use.