The rift between two provinces at odds over a proposed pipeline is straining Canada's unity as it seeks to become an energy superpower.