Many workers are feeling optimistic about the impact that generative AI will have on their skills and career prospects, revealed a new study.