Exclusive: Duke of York said to be cut off from royal family and ‘desperate for redemption’ over Virginia Giuffre settlement