The Force Awakens was the Endgame of Star Wars. The sequel fans had been waiting for since 1983.
With the original cast out of the picture by Episode 9, it was never going to be an Endgame type event (a movie that concluded a decade of story telling).
Maybe had they done things differently and it had actually been the conclusion of the Skywalker saga, it could have done better. It was ultimately the conclusion to the Palpatine saga, and the conclusion to the story of Rey & company (characters people generally seem to like, but not to the degree fans have obsessed over Luke, Han, and Leia for decades).