No, it won't be. There was a while when we had 200mhz computers. Then we moved to 2Ghz computers. Looking at all the innovations that happened within that time period, very few were due to the super computers getting faster.
Distributed computing just means computers getting faster. There is no killer app for this. Yes, you may say cancer research or flight simulations or so on, but there are not the next big things - not the way the web was.