Close to 50 percent of chief executives say that the role was “not what I expected beforehand.” CEOs consider the transition challenging, even for seasoned industry professionals.