It is not so much  hypocrisy, it is just that it is difficult - almost impossible -  to get detangled. Not only only the issues of pipelines, but on everything.

You can be opposed to indentured servitude and child labour, but buy or consume products  that came about because of one or both of these factors. You can decry the loss of manufacturing in Canada, yet you still buy imported goods  at Walmart or the dollar store.

And yes, you can oppose pipelines, while still consuming oil/gas that arrive via a pipeline.

There is an  argument that the pipeline is too economically important not to expand. Yeah, maybe.  But what about the coal industry, asbestos industry, fish farms, seal hunt, grizzly hunt, and the cod fishery.

If jobs and revenue were the only motivating factors, then full speed ahead on all of those? 

Conflicting, and no easy answers. But yes, we sure under-value the environment everywhere.  And we will pay a big price for that