There absolutely nothing upsetting about that to the CEO of your company. I would expect the destruction of your lifetime of accumulated economic value at an age when you can’t possibly retrain to be able to support your previous lifestyle would be rather upsetting to you. Or if not then I would not call that a typical emotional response.
I would be upset, but that is separate to the question posed of whether we should be trying to innovate and automate. The answer is that innovation and productivity should be sought, even though it's understandably not fun for the people whose skills are being commoditized in the moment. At no point in history was it a good idea to purposefully stop innovation just to preserve some job that was about to be automated. The cumulative impact of jobs being automated and productivity is why we have such easy lives today.
And that is all well and good until the pace of automation outstrips the community's ability to absorb the externality. Then it's not going to be the AI dream future, but heads on spikes. We have hit those points in history before.