There are aspects that can currently be automated, but you still have to deal with people, schedules, and interdependencies between projects. Even if you automated everything that could be, you would need, at a minimum, someone to create and coordinate schedules.
Without further details on what you are looking for, I can't think of scenarios where the level of automation necessary to eliminate the role of the project manager can exist.