As AI transforms the professional landscape, workers are split on its potential benefits and threats.