Sure, it'll benefit executives at Energy Transfer Partners, Phillips 66, etc. since they'll have an easy way to transfer oil to be shipped overseas. The states as a whole? Please. The number of permanent jobs this pipeline will create are pathetically low, a couple of people to man an oil field and a couple dozen to deal with the pipeline itself.
Eventually there's going to be less reliance on the USA for refined petrol as more nations move towards renewable energy sources, so the market will eventually correct itself I suppose - but I don't see any reason to help the oil companies make one last push to milk it for all they can before the money dries up.