From my anecdotal evidence, I think that the game is fine as far longevity. I say this because there's still a queue whenever I login, no matter the time. I remember there not being a queue before Endwalker was released. Also, we have Xbox players joining the fray.