Industry opponents praise President for his relentless attacks but other actions including exempting offshore oil & gas from key environmental protections are raising concerns