Where do all these oil trains and trucks travel? Do you seriously think they do not cross rivers or other bodies of water? In fact they do, by the thousands, on these things called "bridges". And a train can derail into a water body, as well as a truck, as easily as a pipeline can rupture. Difference is pipelines can have automatic control valves as well as manual values on either side of the water body to stop flow and minimize potential oil loss in case of something going wrong... moving by train, currently the primary method, is an unmitigated disaster but highly favored by left and presumably yourself because the left's friend multi-billionaire Warren Buffet has an ownership stake in most of them.

Here is a summary of your chosen method of oil transport, many choice photos of the glory of rail transport gone bad: https://www.riverkeeper.org/campaigns/river-ecology/crude-oil-transport/crude-oil-transportation-a-timeline-of-failure/