Either it will get incredibly better, or it will just fade out (except in some applications like execution of process based work, and possibly in the creative arts).
it’ll absolutely fade to the background - AI is phenomenal, but you should never know it exists… it should simply reduce human work by ruling out obvious issues, and at that job it does incredibly well
assuming AI is flawless is where our problems arise