CFO salaries have surged at the biggest companies in the U.S., but the job has become one of the least secure in the executive ranks, according to a new study.