I don't really know the answer to that. I am happy when my own work is replaced by automated tools ("script yourself out of a job every six months!").
It's like getting scooped. If you just founded a startup based on tech XYZ, should you be happy when someone releases an open source XYZ? Should a news reporter be happy when another network breaks the story they were working on? On the one hand, society got the value of the thing you wanted to do. On the other hand, now you need to find something else to do, which might be really annoying.
Why though? There are more important things to worry about if we take "society is better off overall" for granted.
N ote that pretty much every time during the industrial revolution a technology replaced human effort, it ended up creating more jobs and wealth in the long term, while also reducing the tedium and toil of the job. The descendants of luddites did quite well.
Says who?
> Note that pretty much every time during the industrial revolution a technology replaced human effort, it ended up creating more jobs and wealth in the long term
Note that since the 1970s, and throughout the entire personal computing era, median wages have not outpaced inflation. Fewer Americans have access to good schools, median home buying age has increased, access to good healthcare has decreased. So I think there’s good reason to believe the “more jobs and wealth in the long term” trend has reversed for most people.