I really *really* hated the fact they used the 1978 music to help guide Galactica to her fate. This show has grown beyond the original. Bringing it back then only reminded us this show is borne from another show, and it was just unnecessary.
In the new series it is the Colonial Anthem
(has been since the mini)... that seems like an appropriate piece of music to play as the last remnant of the Colonial fleet is finally retired.
Edit: Damn batboy853 and his speedy typing fingers!