The world population is about 7.8 billion, and the current number of bitcoins is about 17 million. If you don’t consider investment institutions holdings, the per capita is about 0.0021794 BTC. But in 2140, bitcoin mining will end, and the world’s population is estimated to reach 14 billion. I want to know what kind of distribution of Bitcoin will appear at that time? Will people use Bitcoin for normal transaction payments? I think there is no right or wrong view, but I believe that there will be other digital currencies to assist Bitcoin. Where will Bitcoin go?
If Lightning Network is successful in its complete implementation, Bitcoin will certainly "normal" transactions. By "normal" I am assuming you mean transactions like coffee in the morning.
I also believe that the crypto ecosystem will have roles to play as well. While none of them will have the same store-of-value status as bitcoin, they will have jobs to do.
In my opinion, most of this relies on LN being implemented properly. If Layer 2 solutions aren't able to work properly (which they do) it could hinder bitcoins progress.