Gamespy is wrong, it's between Ocarina of Time and Majora's Mask.
Also, Bill said a "few decades" after OoT but you shouldn't take that so literally. Miyamoto said Wind Waker was about a hundred years after OoT off hand and in the final game we found out it was really centuries after.
Since there are centuries between OoT/MM and WW, Twilight Princess will fall somewhere in the middle. By a "few decades" he could actually mean a hundred years or so... Besides, Nintendo never cares much about the whole timeline thing anyway and just throws around vague comments on the subject which the Zelda fanboys quickly analyze beyond belief. I mean, I can't help but crack up when I see entire forums produce pages of long, drawn-out arguments over one or two little lines Miyamoto happened to toss out without thinking about them much.
Anyway... GameSpot has two detailed previews up (one on the roundtable, one hands-on) as well as videos of the roundtable...
And if you have GameSpot Complete you can download the entire trailer in HD resolution. The file runs at a bitrate of over 3 MB per second and it's incredible watching it in fullscreen. I wasn't impressed with Zelda's graphics too much before but seeing that trailer in HD really shows you the richness of the colors and the amazing lighting (especially the horse battle and the joust clip right at the end with the sunset). This game is going to look amazing when it ships, especially on a nice TV.