The problem is the data store, and as you said the repeated writing to it, I lost 3 SD cards to this, 4-5 months apart, luckily I had a good backup of the pi, so rebuilding was not to difficult.
My fix… I added a little RPi Zero… build straight buster on it, and installed influxDB. then reconfigured HA to store all data into InfluxDB, going 16 months now, happily. looking at putting a large K3S cluster together, will move the InfluxDB onto the cluster, it will have a nice storage sub system based on multiple M.2’s configured together using either Min\io, CEPH or Longhorn, havent decided
G