Though some jobs will be rendered redundant, others will become more productive and exciting as AI removes drudgery and assists with tasks humans do less well.