Andrew Mountbatten-Windsor's daughters Princesses Beatrice and Eugenie are set to miss out on sweet prospect due to their father's controversy