I think there will always be people who don't want to be completely self-sovereign. But at least they will have the option of handing over responsibility to a party they know personally.
LndHub, LNBank, Galoy and Fedimint are all examples of a project that is custodial but at least they can be deployed and managed by friends/people you trust.