The alternate to pipelines is rail transport, which generates more CO2 to transport the same barrel of oil.

One has to take a holistic approach. Making solar panels requires high heat and a huge amount of CO2 is generated. Hydropower.destroys millions of acres of forests, which then stops CO2 converting to oxygen. 

The only large scale answer is nuclear power, if one really wants to replace fossil fuels.