Future king urged to consider downgrading Prince Andrew's role as a working royal, after the Duke's 'misguided interview'.