Same thing as when we start using (heavy) machinery. You don't need ppl to do "the work" but you need the ppl to design, make and maintain the machines. And much more efficiently then ever before.

I don't expect it will be different this time.

Yes many will loose their legacy jobs. And many new positions will emerge.