I'm playing through Twilight Princess right now for the first time (having more or less played all of the previous Legend of Zelda entries) and the feeling I get when reading your post is that you're a bit over-exaggerating the issue. Sure, I definitely don't need slingshot or sword training, but I really appreciated those sections in the game, because it took me less than a minute or two to accomplish them and more importantly because they fit in with the story perfectly and they are executed in such a charming way (the characters writing, the expression on their faces ...) that you just want to relax and enjoy the ride.
The other option to satisfy "experienced" players would've been to have a skippable/separate tutorial but I would be sad if they went for this kind of design choice. Yes, I know goat herding final function is to train the player to control Epona efficiently but this is done in such a seemless and charming way that even if I do not need that training, I still enjoy the experience. I'll be thinking of it as if I were indeed herding rather than thinking "Bah! to hell with this tutorial, give me a real challenge"
Then again, I'm also somebody who will always play through the tutorials missions/campaigns in all the games I decide to play, so yeah I understand how it would annoy others. Still, I think I can say that Zelda games are up there with the best games series when it comes to introducing new game mechanics. In a way, everything is a tutorial for the next dungeon room where a puzzle of a tad slightly higher difficulty awaits.
disclaimer: I haven't played Skyward Sword yet.