I for one welcome automation.
Finally we can leave this form of slavery behind, where most people spend decades of their lives doing stuff they don't enjoy and is often meaningless anyway.
Unfortunately, I don't think society as a whole is capable of preparing in advance for a smooth transition (eg. by introducing Universal Basic Income, reducing work hours, creating community places/workshops, etc). This way, the change will hit hard and we're in for some rough times. Regardless, in the long run, it's for the better.