Pippin's song is a nice one, but I think Aragorn's coronation song is my favorite. Even when I saw it in the theaters it sent shivers up my spine, now it means even more since I know what the words mean.
I'm kind of sad that they left out the song of Durin's Folk. That one is the all time best (I even have the lyrics hanging on my bedroom wall
).