Prince Andrew 'has no long-term future' at his Royal Lodge home