"Why would we invest in more clean/green energy sources when we have this brand new pipeline?" It essentially hardens the argument (and subsequent lobbying) for these industries.
I get that it is a huge source of income for folks who travel to and live in these areas. However, it's not a forward looking path--particularly when the environmental impact and costs are so high up front.
In that respect, using trucks--while theoretically having a larger short term impact on emissions--allows for future flexibility and doesn't break into the earth in such a permanent and invasive way.
On that measure, trucks are clearly lower-risk. On other measures, they fare worse. There was also the option of running the pipeline through a different area, but the government claimed that wasn't worth the extra expense, and that there would definitely be no spills like the one there obviously was.
[0] https://www.reference.com/business-finance/many-gallons-tank...