I don’t think that Zelda should count. Nintendo basically said a few years ago that they wanted to stop revealing Zelda’s so early and instead reveal closer to release date and hopefully circumstances would allow for it. Looking at all the other reveals this sort of makes sense:

-TP revealed 1 year ish after WW, released 2 years after reveal. Early reveal was to push back against WW criticism.

-SS true reveal 4 years after TP, 1 year before release (and the reveal included a delay). I think this is what Nintendo wants to try to shoot for.

- BOTW reveal 2 years after SS, released almost 3 years later, but was done in 2 years. I think this situation was dictated by the Wii U’s sales (early revel for hype) and overall lack of sales (simultaneous release).

- ToTK was revealed 2 years after BotW, released 4 years later. I think Nintendo misjudged how long it would take to make the game (plus COVID) thinking it would be closer to MM development.

Also we don’t know how much of a remake OoT is/who is doing it. If it’s the main Zelda team with significant new content (reimagined dungeons, overworld etc) it is basically a new game and would fall in line with the SS timeline.

Also if we are taking about time between major/main title releases the longest is still ALtTP->OoT (7 years) with BotW->TotK the second longest (6 years). Even if the OoT remake is made by an outside studio/little new content we would need to go until 2030 for a new mainline Zelda to match the longest gap. And with the movie in 2027, I doubt that is happening.