We can ask hypothetical questions about what's going to happen with
BTC one day when last is mined, but probably none of us who read this will experience that moment. However, this will happen for more than 100 years, and it is much more important what will happen in the near future.
For me personally mining will be almost ended around 2032 when 99% of all bitcoin will be mined, and even before that. Most of us will experience that moment, and whoever is stay with bitcoin until then will probably be witnessed great success. We should not forget that even Satoshi is say :
Right. Otherwise we couldn't have a finite limit of 21 million coins, because there would always need to be some minimum reward for generating. In a few decades when the reward gets too small, the transaction fee will become the main compensation for nodes. I'm sure that in 20 years there will either be very large transaction volume or no volume.