The Queen was the last royal to understand that the allure of the monarchy lies in mystique and constancy, not celebrity