Museum CEO steps down after scathing report