We must have seen a different movie. Rey as Luke’s heir is going to keep the jedi flame alive.
Finn, Rey and Poe will rebuild the Republic along with all their friends. The balance has been restored by Palpatine finally being defeated once and for all. The last gasp for the Empire and the Sith.It isn’t that Luke and co failed, its that the next generation has to pick up the torch and now its their job to secure the future that Han, Luke and Leia fought for.
It is just my opinion and your mileage may vary, you could just as easily say Rise of Skywalker was just a remake of Return of the Jedi. And Han, Leia and Luke were replaced by Poe, Rey and Finn, and that everything ends up the same.
I struggle to see it this way for one simple reason: Return Of The Jedi does a much better job at setting up these future paths for its characters than TROS does. Luke is bound to rebuild the Jedi order because of that final conversation with Yoda. The Alliance is bound to restore the Republic, because with the emperor dead, the Empire might as well pack it up.
On the other hand Rey rebuilding the Jedi order is never a part of her character arc. Her arc ends with her coming to terms with her family identity. In a similar manner, it is never stated that defeating Palpatine’s Final Order would in any way make way for the Republic to be restored (if it is indeed all gone, we don’t know for sure). Most of the galaxy is not even aware of Palpatine’s return mere hours before he is defeated once and for all (and is he, really?), yet the First Order still reigns supreme. Sure, thanks to Lando, the galaxy now finally seems to be willing to fight back, but the true meaning of their victory over Exegol is never made clear.
While I agree that the development you laid out seems to be the most logical, it doesn’t seem to be based on the text of the sequels, but rather on the striking similarity of the current state of things to the situation after Return Of The Jedi