Custodial lightning will probably play a huge part in getting the masses onboarded. Most people do not care about self custody and are fine with trusting a third party. I think many people will only use Bitcoin on layer 2 for most of their lives. It will eventually be too expensive for the average person to do much on layer 1.
I know Bitcoiners will probably cringe at this, but I think we will have a lot of trusted institutions that take care of much of the back end of running lightning and dealing with layer 1. I'm talking in the distant future here btw. As long as they are not able to change the protocol then it should keep them honest, and they will hopefully be structured so that they can't just run off with people's money.
In the more near term I think self custody is still important to protect yourself while these institutions build themselves out and establish trust. We already have some promising ones with Strike and CashApp. I bet MicroStrategy is going to be a big player too.
As the Bitcoin network grows the existing players and new players will rise to meet the demand. More BTC will be locked up in lightning channels and the network will grow more robust. Then there will also be layers built on top of LN like Fedimint and Cashu.
It's mind boggling how this thing is progressing. Most people are completely clueless to how much progress is being made.