A global survey reveals executives are optimistic about AI’s growth but anxious about its risks and potential for mistakes.