Wasn’t there a way to get to this point without Eren coming off as the most pathetic man in the world?
Late, but yes.
If we're going by what Isayama most likely wanted to do at first, it was to have genocide be the actual solution. However, there was no fucking way his editors, and most likely, his publishers too, were going to let that happen considering how utterly massive AoT is and just how much WWII, Nazi-esque, and Japanese Imperialism imagery it contains. To have genocide be the solution, even with Eren "feeling bad" or dying, would entirely unacceptable because of all that.
If AoT just didn't include all that irl political shit, it probably could've been able to get away with it, but because Yams decided to include it, it made it fucking impossible for the genocide ending to work (disregarding it wouldn't even work if the series kept its realism but that's beside the point) without everyone involved looking like a clueless, racist, violent asshole.
It's basically like if a German series tried to do the same thing. It just wouldn't be a good look, bordering on concerning, and because saving face is everything over there, they pulled the plug immediately.
Another reason is possibly because Yams (if he was indeed playing 4d chess, which he actually might've been considering his interviews after the fact) wanted to turn Eren into a loser to smack some sense into all his unironic stans who thought that everything Eren was doing was correct, and there was no other way, and to truly hurt his readers because clearly what he was already doing wasn't working.
The only way to truly hurt them in the end was to just destroy the story. And considering at how a huge chunk of the fandom is
still fucking absolutely
seething about it, (especially Erenfags who have an absolute meltdown now at anyone who even remotely still enjoys the series, or just likes a character that isn't Eren, Floch, Historia, and sometimes Erwin) I think he managed to kill two birds with one stone.
Also, Happy 200 pages! Spend 2022 listening to Linked Horizon to try and remember the days before the basement and the meltdowns.
Lastly, Linked Horizon is not doing the OP this time.
It's by a band known as SiM, and the intro is called "The Rumbling", because I guess it's impossible to hide what's going to happen anymore considering the fallout the ending of the series created.