CDOs are set up to fail in many companies. These talented DEI professionals often experience tremendous disappointment and depart with really negative feelings. An alarming number of corporate CDOs stay less than two years.