I think the largest failure is bad architecture, or that is the inability to understand architecture at all. After your vibe coded project gets larger than a prototype and you "zoom out" to try and grasp what is going on, is when you see how bad it is.