Kimberly Cheatle initially hoped to retain position as head of agency, but lawmakers demanded she step down