I believe if you have cargo in a train that is not demanded by a city, it won't be unloaded.
I think this is the case, anyway. I know that the first game I played in the Southwest America scenario, I tried to ship Gold from one city to another that wasn't demanding the cargo, and the game told me that the cargo would be loaded but not unloaded so this would waste money.