First, the many native bands in Canada have had a variety of motivations for slowing/blocking the Trans Canada Pipeline project - some have been about environmental protection and preservation of heritage, sure, but a lot of it is political.
Band leaders are, rationally, trying to maximize funds flowing from federal coffers to their bands in the form of grants, subsidies, etc. Some use this funding to help their people, and some don't - it varies widely, just like municipalities do - but holding up infrastructure projects is a tried-and-true method of getting more funding.
While bands are rationally acting in their own self-interest, the government has to strongly consider the interests of the nation, state, region, etc. as a whole.
All of these native concerns, plus the potential environmental impact, have to be weighed against the benefits: fewer petroleum shipments via rail, which is much more dangerous than pipelines, tax revenue, jobs in the oil & gas sector, strategically vital energy security, etc.