Prince Andrew is in a tough spot following the latest scandal with an alleged Chinese spy, says friend of the Royal Family.