SD cards are not designed to be written to repeatedly. It’s niot your fault, it’s a combination of raspi creating hardware that does this and the database nature of Home Assistane. It always has been a problem. Using your backup may be your only hope. It is why backups off the machine are so highly recommended.They ALL go bad, some sooner than others.