Sorry to double comment, but I still remember how magical that moment was stepping into the observatory for the first time. It gives me goosebumps every time.
I can play one of the themes on piano. I don't know which one though. I have it on the Skyward Sword cd that comes with the game in the gold edition but it's not skyward sword.