I don't think disappointment was their goal tbh.
Nor frustration.
Not frustration in the sense that the ending is both confusing, intentionally obfuscating, and exhaustingly zeroed in on Cloud at the expense of the other character’s emotions and experiences of the event, but frustrating that the developers in their handling of the ending, make no choice at all, which is I think a really cowardly creative move.
I get their intent, and the desire to create conversation and theory crafting as a means to hopefully sustain interest in the wait for Part 3, which tracks with their handling of Remake’s ending too.
But Remake had the greater creative freedom there to do it. We all knew its endpoint, leaving Midgar, was a high note in the original, the leaving behind of the city and setting out in the open world. That’s left relatively intact, they keep the excitement of the adventure and unknown journey ahead whilst also allowing for new mysteries for the audience to mull over in the wait for Rebirth.
The ending of Rebirth shouldn’t have had this in my opinion, not when they decided to end it at the Forgotten City, and with Aerith’s death.
They shouldn’t have traded one of the original’s most impactful and emotionally resonant scenes, with a puzzle box of innumerable dangling plot threads that weren’t present in the original, mysteries that at once seem to contradict and further muddle characterisations and motivations, that ultimately, like I said before, fail to actually commit to anything at all, for the purpose of vague clues and hints that may mean one thing or another, it doesn’t matter, it all comes at the expense of the story, the characters, the audiences emotional response to the ending of a very lengthy middle entry in a trilogy of games, where the context of how its ending is received now will be changed by how Part 3 delivers on its many questions and promises, and whether it sticks its own landing.
Aerith deserved better. All the others deserved better. Because in the ending they are acting in service to Cloud’s character and his character only, and in service to the pressures of needing to sustain the audience interest by giving theorycrafters plenty to chew over but leaving nothing to emotionally reflect on for the characters we spent potentially over a 100 hours following.
They could easily have kept the current mysteries ongoing, already enough for theories and speculation, and committed to a choice in Rebirth’s ending. Aerith didn’t need to be sacrificed (pun unintended) in what should of been her big moment, her character utilised solely for intrigue ignoring what I believe the vast majority of the audience actually cared about in this moment.
Having a satisfying conclusion to this stage of the journey, and a farewell to Aerith in this entry that actually respects her character and her importance to the party besides Cloud.