CEOs love automation, but don't think humans and machines can coexist in the workforce, survey finds.