Every penny of the revenue from any resource winds up as a tax eventually.  BC will benefit from taxes in many ways...from the workers employed by KM in the province to the ones who live in BC but work in the oil sands.  There are energy taxes, property taxes consumption taxes and even taxes on the right of way for the pipeline.  All of this goes to pay for government services like education and healthcare.  These services are always under financial strain, yet opponents want to increase it.  That means longer waiting lines for surgery and more students in every classroom.  

If you want to go without pipelines then suggest a reasonable alternative that will pay for government services and provide the same high quality high paying jobs.  Tourism won't do it.