I think they do make some kind of a token contribution or allowance to you, but it's definitely not a money making thing (having your ride in a movie that is)
it's true that sometimes a car can get damaged in the process, but from the few I know that did it, they do overcompensate for any damages incurred. in the end it's more for the fame & notoriety of the car itself than the money though..., automatically add at least 20% to the value of your ride & also have it be internationally known by many many thousands who would have never been exposed to your ride any other way.