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.