So the high-sec area I operate out of has seen two successful pirate insurgencies so far and the net effect has been nothing. The way I see it, is you basically get a low-sec system without any of the extra ISK-making opportunities that low-sec normally offers, so the place turns into a ghost town until the insurgency ends, after which all of the locals come back. It’s annoying but not much else.
I can think of a few ways to try and improve this:
Somehow, ISK making opportunities need to be at least as good as low-sec, if not better. New anomaly types seem like the most obvious way to do this.
It should be possible for the system’s usual residents to restore order to the system early. Otherwise, why bother staying in the system? You lost to the pirates (doesn’t seem like anyone wins at this currently, at least not where I am), it’s over, just use a different system for a couple days and then come back. Maybe this is counter-intuitive but a defeat you can’t come back from doesn’t encourage more engagement from the usual system residents. Along with better anomalies, the fight should continue in some shape or form. For example, you get CONCORD back in most of the system, but not in the newly spawned anomalies, which means that pirates who are farming those anoms can still attack you if you try and contest those.
Citadels in high can’t be destroyed as result of insurgencies, the reinforcement timers are too long and the insurgency will end before that. As for POS, I think they are a pain to attack and I doubt anyone cares enough about them to do so.