Less than 24 hours after shocking sexual misconduct allegations surfaced, Charlie Rose learns his fate