AI is killing e.g. React Server Components and Svelte, but for different reasons.
Vibe coding doesn't care about the implementation details, so Svelte is dead.
A unified codebase might be better for humans. But a FE/BE database is better for AI, because you have a clear security boundary, separation of concerns, and well-known patterns for both individually.