Cursor is for programmers. Ultimately, you decide what the code should be.
v0/lovable/a0 will replace drag-and-drop "no-code" tools for non-programmers who don't care about code and only decide what the product should do. The tool will likely also manage hosting, either directly or through service providers, to ensure a seamless e2e experience, automatically fix runtime issues etc.
The question remains, will there be a need for Cursor and programmers in the future at all.