New Talent survey finds optimism among leaders but concerns persist among employees over AI’s impact on jobs.