Yeah, I feel similarly - I'm a roleplayer and I never took the approach of my character being a Warrior of Light or even brushing shoulders with the Scions. He was just someone fairly normal living in the game world who liked to go on adventures from time to time.
Though I can completely understand people feeling disconnected from the Warrior of Light if they choose to imagine their character as one. I think it's pretty jarring how far removed from the professed ideals the actions of the Scions actually are. On the one hand, they insisted that no matter how hard it would be to face the truth the people of Ishgard needed to learn the circumstances surrounding the Dragonsong War. Now they're going around defiling their promise to 'Remember the Ancients'. Y'shtola claims to be writing a book on the subject but I'm not convinced that it will tell the raw, unfiltered truth or even reach the 'everyman' - since the Scions have already comitted to sanitising Venat's actions and covering up the origins of the Twelve.
The Scions also ruined Shadowbringers for me to a large degree. It's the furthest our character has ever traveled - outside of Ultima Thule - yet every prominent Scion was present which meant that only Ryne and Lyna served as consistent companions whilst exploring a new world...and the latter fell away after the first zone.
I can't really get excited for Tural on that basis alone. We're not only stuck with the Scions once again but the story is heavily implying that everything is going to revolve around Sharlayans past and present. I'd have much preferred a clean slate and with only two or three of the Scions deciding to come along for the ride or none at all.
As for Yoshi-P's answers during various Q&A sessions, I do think it's unfortunate that he's telling people to go with their headcanon since the game is so far removed from the idea of giving the player any real agency. I would have loved for the Warrior of Light to want to learn more about the Ancient world and even be saddened and nostalgic towards Amaurot. Instead our character never once really pushes back against Venat to point out how messed up it is to deliberately inflict genocide upon one's own species and then replace them with something altogether different.
It's why I simply laugh whenever the game tries to insist that Venat is a 'good person'. She really isn't. Our character saw Emet-Selch's recreation of the Final Days and then later went back in time - repeatedly - to directly interact with numerous Ancients. All of which proved to be very friendly and even showed kindness towards what they saw as 'Azem's Familiar'. It's pretty weird that the game expects me to be fine with the player character doubling down on the abandonment of the Ancients to a grisly fate knowing that they'll be holding the broken remains of their loved ones.
Even worse? The game will very likely continue to trot out that tiresome and hypocritical quote favoured by Louisoux:
"To ignore the plight of those one might conceivably save is not wisdom—it is indolence."