Actually I've been making several webapps with AI lately, for things I've always wished for and can now selfhost.
At one point I had an idea I brought to AI, got ready to code it, then said "wait, someone has to have done this before me", sure enough, found it, written with warp!
So I can't say it'll kill all app subscriptions, but AI is definitely enabling people to finally make reality out of that idea they've had rattling around their heads but never took the time to realise.
As someone here with limited coding experience. I have built several custom applications that are too unique to be made by anyone. Now I can make several simple applications that do exactly what I need and want. It’s cut out hours of administrative work stuff I had to do. Do I share nope I gatekeep it at work. If only IT built these systems and databases to be easily used by us users.