Prince Andrew's future at Royal Lodge is uncertain as King Charles III did not renew his private security team's contract, leading to discussions about downsizing his living situation.