The expansion of Canada's Trans Mountain pipeline represented a $24 billion bid to help the country's oil producers reduce their near-total reliance on the U.S. market.