I'm trying to think if there was ever any time I replayed a game that I walked away with a different opinion, and I'm drawing a blank. Sure there's quite a few games, like SMB3, SMW and LttP where I've re-played them recently in the past few years where I find myself impressed at its game design or some other trait, but these are games that I've already loved to begin with, and so it's not so much a change in opinion. Same goes for games that I'm not as hot on, like Majora's Mask or SSBB. I'll probably appreciate some individual aspect but overall, they most likely would remain where they are.
I haven't finished Skyward Sword yet (and I have a LONG ways to go), but hypothetically, even if it ends up disappointing me (which very well may be th case, sadly), I seriously doubt that I'll be feeling that TP's suddenly a marvelous game again. I could be disappointed with SS yet still rank it above TP, bu again that wouldn't make a lick of difference. I like what I like or dislike what I dislike, and it's pretty much it.