I think it is really going to depend on how “media” approaches it.
You clearly want it to fail. So do a lot of people. It is the same logic behind how every single Battlefield is the worst game ever made during beta/launch (and all the fans keep saying “Never play Conquest. It has always fucking sucked. Play Rush”) which lead to the first year being “Can Dice fix this unprecedented massive blunder and make this game good?”.
Or… just look at how everyone danced on the grave of Concord basically immediately.
And a lot of that is because, as Yahtzee et al taught us, it is a lot more fun to shit on something than to admit we liked it. Talking about how it is the worst furry fanwank ever is a lot easier than putting yourself out there and acknowledging that Dust: An Elysium Tale’s themes of courage and ethics in the face of inevitable failure unseamed you.
Starfield was a new IP. It was also a game that was “okay” at best with a lot of the Bethesda jank. And the world map traversal was HORRIBLE but… so was exploration in Mass Effect and we loved that until the last hour of 3.
But also? Look at Fallout. There are people who will argue that all the Bethesda Fallouts shat on the originals (and ignore that most of that nonsense and lack of cohesive theming was there since 2 but…). But 3 is almost universally loved (outside of the NMA crowd) and New Vegas is that game everyone claims to have loved but almost nobody actually played. And 4… was definitely a step back in a lot of ways. But it had a strong marketing campaign and, gameplay wise, was perfectly fine if not better than 3. So after that initial hatefest it is pretty well regarded.
TES6 will obviously have a very strong marketing campaign. There are going to be the people who will say it is shit but most of them will ALSO start talking about how Skyrim was shit and Oblivion was the last good Bethesda game (us Morrowind fans will be too busy watching Matlock re-runs) which will rapidly undermine them. At which point it will boil down to whether people want that kind of open world game.
All that said? I have an increasingly bad feeling that Microsoft is killing Obsidian to save Bethesda because TES is a much more valuable brand than Pillars or just “we make amazingly good games that are missing the last five hours”. Starfield being “fine” hurt it, but it was very clear people were desperate for a “real” Skyrim after the horrific sin of basically making a Fallout 3 scale game in Outer Worlds.
But when Avowed hits next year and isn’t “Baldurs Gate 3 but on the scale of Skyrim but also better”? Obsidian gets shitcanned (likely while Phil et al talk about how Pentiment and Avowed are exactly the kinds of games MS needs to make) and the entire TES6 marketing campaign becomes about how Microsoft and Bethesda are sorry that those horrible evil games exist and they have hired a bunch of influencers to help them make sure they make the game right (see: CDPR and Cyberpunk) and that TES6 is going to be a return to form that is informed by What Players Want ™.