I think this is an example - much like the whole thing of Raffi and her comments about Picard being rich - where the Picard writers decided to just ignore established Trek just because they didn't like how anodyne it was.
The lore didn't make any sense. There are a hell of a lot of humans in the galaxy, and only limited space on earth. Only a few can have the privileges Picard does, and a degree of resentment is not surprising.
The lore in that respect was never really established either - it was lipservice at best, likely because the writers through it was, in Ron Moore's words, a bunch of hooey.