Prince Andrew has been told he must "take a long hard look in the mirror" and "make the right choice for once" to salvage his reputation