Abstracting away infrastructure just means it will become increasingly centralized as a commodity and less likely/harder to create independent services.
Look at n2n or userbase, they’re open source and can be self hosted.
Other nocode tools can follow suit, and can be federated.
I agree with the other comment that this can have the same effect as the one Excel had during the past decades (there are companies running completely on Excel).
Sure they can be, but the whole ethos behind it is "don't make me think about anything other than the application."
So by default the majority are looking for hosted services, otherwise they'd just build their own stack. For anything other than some organization building a bunch of applications, that same Nocode Dev has no need to ever migrate so long as some major service provider is doing it for them.
Abstracting away infrastructure just means it will become increasingly centralized as a commodity and less likely/harder to create independent services.