I think they want to take Zelda to places where the series have yet to be.
I vastly prefer the OOT style (I would call it the aLttP-style) over BotW. But even so, I want them to change what they can in order to keep Zelda feeling fresh without losing its distinct Zelda-feel. And I just have to accept the the series might not be for me anymore.

I suspect there will be a few implications. A Majora's Mask remake, while by no means guaranteed, is definitely possible. They could even do it as a standalone expansion type deal similar to what Xenoblade does given it is a more compact game.

I think we're definitely seeing the foundations of the next Zelda's rendering and visuals laid. It might not be exactly the same, but I think it will take a lot of cues from this.

And then finally, I think we will see the next open world Zelda feature more and larger, more traditional dungeons. I could see them scaling shrines back to a smaller number, 40 or 50, and having several large dungeons. Tears began a move towards this direction, I expect the next to only continue it much more aggressively.

I don't think anyone realistically wants more traditional 3D Zelda games that are original. There is a reason why the franchise needed to move in a new direction - even if that new direction is now again in need of an even newer vision. Traditional 3D Zelda games were amazing at their time, and OoT is still one of the best games of all time. But the formula is archaic, and results in games that are very limiting. Traditional Zelda works best in 2D-3D style, and I'd love to see more in the formula, such as a Link to the Past remake. But beyond this, the series needs something fresh. It can't keep going back to the past for inspiration.

A Majora’s Mask remake is the most obvious result. But I wouldn’t rule out that classic 3D Zelda could make a comeback if Ocarina sells really well, like 15-20 million. At that point we could have the franchise splitting into three with open world 3D, classic 3D, and 2.5D 😅

This would be a dream of mine. If Nintendo viewed this as a template, something that proves the OOT formula still works, and that people still love it, and thus, created a new Zelda in that style? Oh man. It would really excite me.

I kinda wish they had just done this behind the scenes instead of releasing it, then gone with the above. OOT is like the Mona Lisa. You shouldn't touch something like that, imo. You make something new inspired by it, but you leave the GOAT alone.

Sorry to veer off the question a bit. But I have some thoughts on the implications of it beyond the cosmetic (which, IMO look great).

I’m not a dungeon crawler fan, and I generally prefer open world and sandbox elements, so I’m really hoping they don’t turn the next mainline Zelda into something more resembling Ocarina of Time. If anything, I’m hoping they shorten the divine beast style temples, those were the only places in Breath of the Wild where I felt “you know what, I think I’ll put this game down for a bit…”

More or less, I want more exploration, not the addition of linear.
I want more towns and more ability to live/make a life in the overworld, not more dungeon crawling through temples.
I want the next Zelda to feel even more unique from game to game. I’d say around 30% of what I saw in game 2 was stuff I was seeing for the first time (there was an entire canyon that was massive in scale, and a hidden and rather large semi-underground network of ruins). I want that number to be even higher.

Zelda was always Dungeon First game, from its very conception, whether it's combat dungeoneering or environmental puzzle solving. Depending on era and person in charge, its overworld was more or less linear, but, until BotW, it was always (I'll repeat, always) item gated and in many ways akin to Metroidvania, with a goal of getting you to next dungeon.

Personally, I always thought Nintendo can theoretically make a game that will satisfy both (or more) Zelda fandoms, but obviously there are people like you who essentially don't like Zelda's core design pillars, so maybe there is indeed necessary divide in their future approach to IP and catering to different fandoms.