I'd not given it any thought prior to reading the OP of this thread but I think Founders would be a good place to escalate how players perceive a Thargoid Incursion.
Firstly there is no way (AFAIK) for players to prevent an attack, so Jameson Memorial is as good a target as any, and the removal of outfitting & shipyard stock from there would create strong motivation amongst the community to get the station repaired (and maybe help create a little respect for the PvE truckers).
Thargoid NPCs could act more like the Police in High Security systems, bringing a significant NPC threat to any realspace instance created in the system (ie any interdiction or USS carries a significant risk of Thargoids showing up to investigate), jumps in & out of the system by players or ships meeting certain criteria might again generate a significant NPC threat to be countered either by force or guile. It could be good.
The station would be repaired of course, by motivated players that would need to continue to bring in supplies & research info to maintain station services for the benefit of all. The Thargoid incursion could remain an existential threat in the system to discourage players from hanging around too long in any one area, it could be a good place to have a persistent Thargoid presence.
And of course it wouldn't affect newbies because it would be gated by experience. There is a lot to like