Raspberry Pi is a bad choice for any application that frequently writes data to disk. Most Home Assistant setups will often have historical tracking of at least one data point, which means that it would be constantly writing to disk.

If you get a high quality SD card with more storage than you'll ever need (64GB, 128GB), you can have a stable system for a while until the SD card becomes corrupt. The larger SD cards help with longevity because it means the SD card can spread writes out over a larger area, which means it'll take longer for the SD card to go bad.

Make sure to always have RAM logging enabled on your Pi! DietPi defaults to RAM logging.