Sure, a big preventable breach might easily cost a CISO his or her job--just ask Susan Mauldin, the former Equifax CISO. A few less obvious missteps could do the same.
https://www.csoonline.com/article/3237797/it-careers/5-missteps-that-could-cost-cisos-their-jobs.html