The problem is, those attacks afaik, are few and far between, and unlike in a cutscene where ships were focusing on one target and taking them out, you end up in a chaotic fight, which can be fun. But like with CS:S if you're the first guy to die, you end up pee'd off and a month away from the next major attack.
Its the, literally months of mining you do before you get a decent ship thats completely boring, and the mindless and boring chore that is buying decent mining ships, taking them out, mining, seeing a pirate/enemy player, warping back, switching ships, coming back killing them or scaring them off, or finding another system to mine in, then rinse and repeat for months as your skills train up completely on their own completely not based on how much you use them or what you do.
Ok I haven't played in a good couple years now, maybe a lot of years, but sitting in a mining ship, while waiting weeks for my skills to level up so I would actually have enough money to buy ship and fit it with weapons, honestly, just completely boring.
If you could walk into the game, start off with a decent ship, skills to use weaponry and you can join fights like that all day long, yippee, but you can't and don't and thats where it fails.
personally I'd love to play a single player game based on it, with a superb story, thats ridiculously long and has lots of choreographed battles, starting with an opening sequence where you, I dunno are in the lowest support ship get into a fight and due to the way the story starts are on the losing side and are forced to retreat. Character levels up, moves through the story moves up ships, and ends up taking control of fleets and battles yourself.
This is the issue, if i want to get into a fight in this game, at this stage, you'd never be the guy calling the shots now, coming up with tactics, you'd be the lowest guy in the guild, unless you were in on day one you can't hope to match the money/ships/weapons of other people and its just now an elitist game you really can't get into.
I heard they started the game with a hugely higher skill points now, but when I was playing I was literally 6 months from even being able to use the ships I wanted, if I played 0 minutes a day or 24 hours a day. Fundamentally for me, you puts your time in, kills your ships you should be in equal footing.