I think there's always going to be people who (have to) rely on others for their security. Even if it's "please set up my self custody for me".
Not everyone will hold their own keys, but the vast majority of people would be able to self custody. With time it's only going to get easier and more secure, so I'm bullish we'll increase that number over time.