The president is torn between the job-creating potential of the US energy boom and his desire to be remembered as an environmental champion