The problem is that when you build this infrastructure, it comes along with long-term financial contracts. Which is to say, if you build it, you're gonna use it.
As a result, it discourages investments in other energy infrastructure projects. Once the pipeline is in, we are stuck with it until it ages out of usefulness or if green energy radically undercuts the profitability of fossil fuels such that the pipeline is abandoned. But because of those long-term financial contracts, the likelihood of the pipeline being abandoned is far less than it would have been if trucks were used instead.
Small short-to-medium-term risk, larger long-term risk.