This is not taking into the fact the amount of trauma that the Federation and Earth has taken over the last 30 years. The Borg, The Dominion War, even something as small scale as the Maquis effected it (showing cracks in the system as it were). Then the Romulan exodus. This is where what @anon61221983 said earlier of “can slip backwards” occurred. Earth of the late 2300s is struggling and Picard puts that on display.
EDIT: a tweet I saw the other day sums up Star Trek pretty well for me: “Star Trek has always been a mirror. How you react to that reflection that is the important part”
