From what I have seen the ratio of poor CEO’s is basically the same as any other upper management position. Based on that the number of terrible CEO’s mostly comes down to selection process not inherent difficulty.

Child of old CEO, internal promotion, or executive have wildly different applicant pools but you can find great or terrible CEO’s chosen based on each.