There's a good story to be written based on the theme of what happens when society generally realizes that there are ineluctable limits to achievement and knowledge. SF tends to proceed on the basis of the idea, encouraged by our technological advances and astounding gains in knowledge, that (if nuclear war or, more recently, planetary overheating don't do us in first) the trajectory will continue till we have explored the whole galaxy and maybe more, have practical immortality, etc.; every seeming barrier, ever problem, can be overcome given time.
But in fact -- well, I start with this: for centuries there was, I gather, a tendency for the average person to get taller, century by century. The cliche is the tourist looking at the suit of armor and thinking how small the wearer was, etc. But we won't go on getting taller and taller, especially while living on earth. Again, the record for running the mile may be improved, but it will not keep on being improved forever; at some point there will be a record set for running the mile that, 50 years or more later, no one has beaten.
There's the assumption that human will live on other planets. But I wonder. Supposing civilization endures that long, say 300 years for now will humans have traveled to Mars, even? There's that matter of cosmic ray exposure. I have no objection to stories that wave that away, as a problem that will be solved; but what if it is insoluble? How will people adjust to the reality that we are not going to Mars, let alone to the stars (which has tremendous problems -- likely insoluble -- aside from cosmic ray exposure -- the oft-invoked suspended animation solution is, I suspect, a bigger problem than many people think).
And so on. I wonder what it will be like to live on earth if, 300 years from now, or even by the end of this century, it has become clear that most of the science fiction assumptions were never going to be realized.
When I discovered Geoff Ryman's concept of "mundane sf" I felt I had discovered a kindred spirit. But, again -- I'll go on enjoying stories with FTL travel, and gobs of Jack Vance colorful extraterrestrial civilizations and so on. Sure, why not? But for mental hygiene I think it's worthwhile also to bear in mind that none of it may ever happen, nothing like it. In fact the evidence tends the other way.