The chief AI officer is not a conventional role, but it is critical as AI pilots move from a proof of concept into real production impact.