This SmartApp can't be deleted at this time because it is installed by one or more users

Yes, there is no way to fix it at this point due to Google dropping the Nest API for integration for new integrations. Existing integrations are fine unless you disconnect and after that you are out of luck since you will not be able to reconnect now.