Don't get me wrong. I agree with this. By and large it's still a pipe dream, but some dreams do come true. With that in mind, I won't bank on the fact that something won't materialize that lowers the barriers a bit.
Granted, more complex problems will always require more complex solutions. I don't see anything like this changing where I work (quantitative finance), but it'd be more of a concern for those working at J-Random Cardboard Box Company.
One could argue that this has already happened to some extent (where the domain model is commonly known and well explored: blogs, ecommerce) via packaged solutions and web frameworks.
Don't bet on it. There are tons of failed examples of attempts to enable plug and play programming (connecting pre-made components together), and it never scales. The devil is in the details.