The president citied concerns about the impact on the environment and a political climate that overly-hyped the pipeline’s benefit.