My understanding is that transporting oil by rail takes more energy (so more carbon), and if things go wrong, they go much worse than if things go wrong in a pipeline.

I think pipelines make sense as long as we are continuing to use oil. This particular pipeline project was pretty stupid though, and kenny's support of it was either gross incompetence or an indirect way to defraud tax payers.