It'll be disruptive, but not apocalyptic. Some classes of jobs common today will be eliminated, while more will grow. Overall productivity will increase, but it'll suck for the people made obsolete.

Certainly it will not result in most people working fewer hours.

Source: see the adoption of computers/databases across previously pen-and-paper industries 50 years ago. That was more disruptive than this will be.