Yes, Skyward Sword was a definitely a big announcement! It is one of the most anticipated games of this year (and maybe in all of history...), and Nintendo really did know how to wow the fans when they started their conference with Zelda right away.
A lot of other big things were announced, as well. Sadly I only got to see the Nintendo conference, though. Metroid: Other M was a pretty big title, and they were bringing back a lot of the other classics, like Mario and Kid Icarus. Kirby's Epic Yarn was also announced, along with Resident Evil, Kingdom Hearts, Goldeneye, and all of those other big titles.
I would have to say that Nintedo took the show away at this year's E3. They were just amazing, with all of those great classic titles and everything. And Zelda was definitely the highlight there, especially with the announcement of Ocarina of Time's remake on the 3DS...