If you've ever wondered what happens to retired race cars, you're not alone. The answer varies, depending on the type of car and what kind of shape it's in.