But trains and trucks will definitely be used. And will use more carbon.
It’s pretty similar arithmetic that this will result in more carbon released.
Comically, the way to stop production is to lower the price of oil so extraction no longer makes sense from these locations. If anything a higher price for oil means more extraction because it becomes more profitable. And more oil transported using dirtier means.
Oil spills from trucks and trains are much more detectable, meaning residents don’t need to worry about them secretly contaminating water supplies. Pipeline spills are harder to detect, so you don’t necessarily know until oil has already seeped into the ground.
There are a lot of good reasons to stop oil pipeline projects.
As to transportation options, boats and trains are extremely efficient to the point where pipelines don’t make that big of an environmental difference.
Also, quote from [2]: While long-haul oil and gas pipelines are also more economical and environmentally friendly than other modes of transport like rail or trucking (pipelines create 61 to 77% less greenhouse gas emissions than rail when moving crude over long distances, says one recent study), they also have a safe delivery rate of greater than 99.999%.
This is quoted from Enbridge's website, which is a pipeline company, which may be a bit biased, however I doubt they are lying.
[1] https://www.forbes.com/sites/jamesconca/2018/10/11/which-is-...
[2] https://www.enbridge.com/Your-questions/User-submitted/Why-a...
As to being lower cost, again the lower cost isn’t a savings for the environment it’s a savings for the oil company.