The arrest of Andrew Mountbatten-Windsor on suspicion of misconduct in public office is the "worst possible thing" for the Crown, Sky News' royal commentator has said.