If bitcoin really became the backbone of the world's financial system, as every bitcoiner dreams of, it will be impossible for anyone to have a transaction confirmed on the main chain. The fee price will be so high that only corporations, financial institutions and governments will have the cash flow to do it. Second layer solutions demand a main chain transaction, so it won't help. Even early adopters will be forced to move to second layer solutions.
At this pace bitcoin is becoming a tool for the system it was created to destroy.
Well yeah of course once Bitcoin is used a lot 99.9%+ of transactions won't happen on the main chain. And you seem to be confused about second layers if you think it won't help. It is literally designed to help this. With, for example the main L2 solution currently, the LN, you can do a single on-chain transaction and then do many off-chain transactions, potentially thousands. So of course doing thousands of transactions for every single on-chain transaction helps!
Yes EVERYONE will use higher up layers in the future. That is normal and expected. All financial networks work in this way. Higher layers are for efficiency, lower layers are for security. Anybody who has a bank account regularly uses the higher layers and not the base layer of the fiat system. Bitcoin will be the same, except you'll be using Bitcoin instead of fiat and banks.
The base chain will only be used for on-boarding onto higher layers, and moving large amounts of money around. Think about it this way, if we're talking about Bitcoin being used on an everyday basis in a way that can completely replace your use of fiat: you do a one-time onboarding transaction to let's say the LN, you then get paid your paychecks on the LN, and spend money on the LN. You're spending your paychecks and getting your LN address refilled with each paycheck, so ideally you can do that indefinitely. The Bitcoin ecosystem will probably need other L2 solutions, and perhaps even L3 solutions built on top of those.
Also lots of people just care about convenience, and don't care about having a decentralized self-banking currency. So many millions of people will probably just have custodial wallets in which the custodian does the vast majority of the transactions off-chain and the users never even hit on-chain at all. Everyone is used to using banks, most people are gonna prefer their bitcoin being used like they used banks, rather than bitcoin displacing banks, and so banks or crypto companies will hold their bitcoin and everything will be handled for them internally at these custodians or on higher layer networks between custodians. Layers, custodians, etc scales Bitcoin's 5+ tx/sec to thousands of tx/sec. The ecosystem is going to be developed so that people can avoid having to pay a ya know like $100 fee even a single time to hit the blockchain, cuz nobody wants to do that.
The business models of the bitcoin ecosystem will be developed around users not needing to hit the chain and pay large fees. Thousands of transactions will be done for every single on-chain transaction. This will require a lot of building. Bitcoin is still very early stages in the grand scheme of things. Only a tiny bit of the eventual ecosystem has been built out or even thought up at this point.