How do you actually stay consistent with habits?

I get motivated, build a routine, then one small slip ruins the whole thing. I miss one day and suddenly it feels like I’ve failed and might as well stop. How do you stay consistent without burning out or giving up? It’s honestly so frustrating.