lightning is final settlement. the argument of what "most people" use is subjective. we are talking about the properties of the technology. you can of course make the argument that cashu can support a larger number of users, but so can a sqlite database and visa.
cashu is better payments tech than visa, it is not better payments tech than lightning (for non-custody and finality). The arguing past each other is just this tradeoff that some people are not willing to make. custodial solutions are a line in the sand for most bitcoiners.
If its custodial its just not worth investing lots of engineering time into, unless its for small fun things like a persons first zaps. I am not completely against sqlite/tigerbeetle databases for that purpose, as long as its more of a demo account and can't be used for storing lots of sats.
many of us old timey bitcoiners got into bitcoin specifically for the non-custodial properties. its not that surprising that we are not as excited about it as all the ecash hype people are on nostr.