I think it's wonderful that they do that to salute the captains after their years of dedicated service. I'd feel honored to be on board for a captain's farewell flight.
Reminds me also of how one time this sort of thing didn't go so well - link is to a story from UA forum.
http://www.flyertalk.com/forum/showthread.php?t=636222