Being the fanboy of the series that I am, it's hard for me to describe my feeling without using very unhuman sound effects of joy. Although, I'm interested in the fact that a dragon was shown, even if it was just made of stone, since they're considered extinct in lore. Along with that, the Dragonborn it spoke of also intrigues me.
But that part aside, I'm really glad they finally announced it, now I can look forward to Skyrim, which I hope will have more environmental diversity than Cyrodiil did.
EDIT: Actually, I should pay attention more, the trailer pretty much spells out the dragon thing. Meaning it's more than likely the return of the dragons.