Prince Andrew has become comfortably Britain's least popular royal, creating significant pressure on Charles to disown him.