Are you sure this isn't a strawman? The recent Dakota pipeline protests for example were very clearly about water safety and building through native burial grounds and other historic native sites. Pretty much every pipeline protest I can think of is more concerned with environmental danger of spills, not reducing oil. And a catastrophic pipeline spill can be much worse than isolated truck spills, though I'd love to know more about research on that front.
So standard NIMBY? "I think oil pipelines are great, just not in my backyard!"