With a Senate vote on Keystone expected Tuesday, Obama is suddenly embracing the view of pipeline critics