Part of the problem is that BC isn't getting a lot of the financial benefits.  According to the Conference Board of Canada, BC is only getting 12% of the benefits.  So we get an increase in risk all for what?  A paltry sum.  Seems like a raw deal to me.  

To be fair, transporting oil by pipeline is far safer than by rail which is what is currently being done.  However, I haven't seen any quantitative figures on the risks regarding this pipeline - and the tankers.

Ultimately, this is the lesser of many evils.  It could be worse, we could be talking about coal.