Last year I decommissioned a Pi 2 that had been running nonstop pretty much since it came out, with the same SD card. I used it as a camera/motion detector for my garage, so it isn’t like it had the perfect environment. I also have a pi 3 that runs nonstop collecting data from a couple usb peripherals. I have a pi zero W running as a print server for the last 2-3 years, and a pi 4 with multiple services and docker containers for the last 1.5-2 years. I have never experienced an SD or pi failure. I only buy the power supplies recommended by the pi foundation. I also gracefully shut down vs. yanking power (but I do not have these on UPS, so they do occasionally experience power outages)