Queen Elizabeth II was "deeply concerned" about Andrew Mountbatten-Windsor's future, a new royal book says.