Well, you can turn this into a complex discussion: reliability, maintenance efforts required, amount of community experience and support available, performance, pricing, energy & space consumption, compatibility issues with different processors, I/O boards, OS versions etc etc.
Pis are a fine tradeoff as long as you offload disk writes to take care of the SD card corruption issue. Use a USB stick and/or NAS (if you have one).
Still - and that’s true for any other server as well - as you increasingly rely on home automation, you should prepare for as many types of outages as possible.
While a SD card will crash (often), any SSD can fail, too. Or your radio stick breaks. Or your router. Or or or …
What you really need is to identify all your single points of failure, and then come up with a comprehensive HW and OS backup strategy.
See also this thread for some more hints and discussion.