Just read online that Picard season 2 will get into some time travel shenanigans. They will go back to 2024 where Deep Space 9 went during the "Bell Riots" set in L. A. of same year . America has entered a autocratic period and the homeless, mentally ill, etc are sequestered in Districts that are in every major city. They have no connection to the world and America has no idea what is going on in those districts. Sisco ends up taking the place of the Glenn Bell who was given credit for the riots, since he gets in the way and the real Bell dies. I just rewatched these two episodes of Deep Space 9 on Netflix. Season 3 "Past Tense"- two parter episode. Everyone should rewatch them for themselves so they will be familiar with the entire premise they are setting up for Picard.
So they will most likely be revisiting the same area and topics that they did. In Star Trek history the 3 world war starts in 2026 between the U.S. and Econ- An eastern nation. All cities on the world are destroyed and 600 million people are killed. Then by 2063 they the Vulcans will meet what is left of man kind ,like they did in the Next Gen movie Star trek : First Contact. This sets the earth to unite and stop tearing themselves apart like we have since time began and then to creating Star Fleet.