IME most managers became managers because they preferred working with and helping organize people to creative contributions. I don’t see the need for any of these functions going away. I see productivity differences. Maybe the roles evolve.
I think the real question is how do we best harness the increased productivity? Logically speaking, if each person is 5x as productive because of AI there should be an equally greater capacity to get things done. Businesses aren’t just running out of work to do, right?