The idea of a Federation collapse went back to Gene Roddenberry, who wrote the basics of a story of a Federation starship that got pushed forward through time to a post-Federation future with the goal of rebuilding the Federation.

The first iteration of that idea was Gene Roddenberry’s Andromeda. Kevin Sorbo ruined that series.

They did better with the idea the second time around.