Will vibe coded spaghetti code lead to unmaintainable software?

Job security via code obscurity.

More careers to maintain and unentangle and rewrite such code bases.

Yes. It already does.

We may not be the ones doing the maintenance. An LLM may be able to maintain spaghetti code. A human, less so.

I have a good news for you: the code is already unmaintanable.