Seriously, the Zelda team has been making such a wild variety of character designs since the N64 days, and the more realistic artstyles have invariably made those 200x weirder and more uncanny than they should have been, even downright horrifying.
Twilight Princess has simply horrendous characters. It gives the same effect as the Layton x Phoenix Wright crossover - it's effectively designs from different games being shoehorned in a single game, making it look like every human belongs to a different evolutionary branch and making almost every character repulsive on a very visceral level. Add the Team Ico-style bloom to it all, and it's seriously the only Zelda game I'd like to see remade in a different engine.
Skyward Sword had its share of odd designs, but the artstyle was a much better fit for those. Same for the Switch Zeldas.
The N64 games and WW had the perfect artstyle for those designs. Those never felt out of place.
When you think about it, Nintendo has been very brave in overhauling the look of the series so many times. They never cease experimenting, even if it's their flagship IP. The natural evolution of the N64 Zeldas would have been to go for the most realistic style the tech allowed for at any given time, but they decided otherwise and it was the right choice. TP was the only time they chased trends, and the result was of course a derivative, soulless game that would have fit right in the PS2 library with a slight change of name.
