Twilight princess appealed to the mainstream, not quite as much as OOT, but it still did it pretty well. It used an art style everyone could like.
That's quite a statement. Everyone? I, for one, felt it was a huge step away from what makes Zelda, Zelda. I did NOT like the graphic style at all, and felt that not only was it not very Zelda, but pretentiously dark for no better reason than to pander to immature kids who begged for a darker Zelda.
The day we see a photo realistic Zelda with blood gushing from every sword slice is the day I'll stop playing the series because it will have stopped being itself. Zelda is quirky, and colorful and fun. It has some dark moments, sure, but it also has some wacky, hillarious, sad, joyful moments too.
Fans of OOT would have liked TP, it had similar elements and the sense of familiarity would have been a comforting return to how zelda used to be, before the WW came out and made changes.
TP was not a return, TP was a departure. It moved away from the colorful, vibrant world Zelda has always had. TP was a step away from that, and was melodramatically dark just to be dark. SS felt like a true return to what makes Zelda, Zelda.
A friend of mine came over while I was playing SS. He was a gamer when he was a kid, but now that he's no longer in HS, he doesn't game hardly ever. He said, "Oh, that's the new Zelda? Wow, it looks like they finally went back to their roots."
OOT changed gaming as it was in 3d and people loved it)
Not everyone. I have some older friends for whom ALttP was their last Zelda game because they did NOT like the move to 3D.
SS, however has been heralded as one of the best, if not the best, Zelda games ever made. And I feel it deserves that. It really does feel like a return to the roots in terms of graphical style, but amazingly innovative in terms of gameplay.
As for why it's gotten so much hate from gamers: gamers incorrectly attribute "mature" with good and colorful with "kids-y"/bad. When they grow up, they'll see how absurd their notion of "mature" is. Critics by and large have given it great scores. And the few reviews I've read/seen where a bad score has been given, it was clear that the reviewer was mistaking their ineptitude as an issue with the game (controls issues in one infamous review, wrong assumptions in another, poor journalism in a third). I think that in the wash, SS will stand the tests of time as one of the best videogames made.