Agreed overall, but where you feel something is lacking, I see an original and successful take for a game that was meant to do its own thing. You used the word impersonal, it's very important and deliberate from the creators.

I had heard a few times the main character of this game is Hyrule itself, it sounds cheesy at first but that's what it really is in my view. It's a world in ruins with a thriving nature, where you basically only get meaningful insight from spirits or really old people. Most personality traits are expressed through memories, as story was indeed designed around those to play with non-linearity. Ganon himself was kept impersonal for this game.

Zelda however is the keystone of that story, from memories of her early struggle to her late deliverance. (Some American voices didn't help but the overall game deserves to abstract them away). The game ends on her being finally free and talking directly to Link/you, in the present moment. It's as cheesy as it gets but it's a fitting moment that offers some very personal closure.

In the end it's up to preferences. I can see why the non-linear storytelling didn't work for everyone, or why you would be looking for something other than what was the focus this time. I also share the opinion that the ending's delivery was underwhelming: Ganon's designs were amazing but he was really easy, his personality was by design non existent, the outro was short and didn't say much after a very long adventure. But the overall themes and presentation worked for me, and I'm excited to see what they do for the sequel.