If you’re from the US, you’re probably burnt by your mobile providers. I don’t believe I’ve heard any horror stories about esim in my country and our neighbors (except for the fact that you still have to pay $3-5 to switch to “esim”, as if you are getting something besides a string of numbers)
Here is my use case: 0. I have a device with 1 sim slot
I have my main physical SIM-card with a known number (relatives, work partners etc). I have some data there as well. This is my "daily driver"
I have a separate e-sim with an “unknown” number that I use for sms-verification things for web services. It also has some dirt cheap data (but the coverage is not great).
At least on Pixel phones you can have a physical and e-sim card both active at the same time, and you can choose, for example, “sms and calls default to 1, mobile data default to 2”. There is an option to "switch to another sim for data, if the signal is bad. (There are talks about simultaneously active several e-sims, but it’s not here yet)
Even if you discard a security angle (sms verification should not be a known number - “restore sim” attack is quite common for a targeted action), a lot of people can benefit from “1st physical sim has great calls plan/ coverage, 2nd sim has cheap internet”