Whilst the interest in collecting from change may fade away, the interest in rarities, especially nice ones, is likely to be subsumed into the general collector desire for quality rarities seen across all spheres. Otherwise, how do you explain the prices paid for hammered coins, none of which circulated in living memory. Their desirability stems from the history and all coins are part of that same history. Not all denominations have a large following, but one day their turn will come when relative rarities are fully appreciated. Take halfpennies. Much rarer than pennies in top grade because alongside farthings, they were the mainstay of the working class cash economy. That means a high grade example is always a good long term bet given they weren't normally set aside and collected per se.
It is a common thread throughout history. Look at Roman sestertii as an example. These were the circulating base coinage of the Roman era, and again, not something the rich and famous would set aside. However, the Bolsena Hoard found in the late 19th century in northern Italy provides ample evidence that even 1700 years ago someone thought them collectable. As the hoard contained a large number of top grade sestertii spanning a few centuries, it beggars belief that they were collected from circulation. The hoard only makes sense as a collection. i.e. we are just the latest in a long history of people who collect from interest, rather than as an investment.
As I wrote in my testimony to Cope part 2. We 'met' on ebay. He, as my regular nemesis, eventually asking if I was a copper collector. Silly and obvious really. When we had both bid over twice book on a lustrous 1718 halfpenny that came back in the sale as a 65RB, it was clear that we both appreciated the relative quality of the coin, and how infrequently they turn up. High grade modern pennies will also fall into that same collectable category once enough have been melted and are no longer readily available, and this might happen sooner than you think. In the past 20 years, I estimate that I have consigned somewhere near a ton of bronze to be melted of all denominations. Why? Because nobody wanted them, so you melt to free up cash. The odd rare piece will have gone through undetected, but the vast majority will have been worth scrap value. I am not alone in having done this. This will increase the relative abundance of the rarities over time.
Every dog has its day, and as far as I can see, always will do so on a recurring basis.