The thing I'm most excited about with 'vibe coding' isn't really existing software developers making things. It's people with deep domain knowledge who can't program can now build stuff. It's more of an excel replacement imo as it gets into the mainstream.
I am sure that most LLM generated software projects are more easily understood at a code level than the average excel 'megasheet' created by this kind of person, and certainly will be less brittle to a certain degree.