IPhone Xs, the first one with dual SIM, had physical + eSIM in most of the world, but dual physical SIM in HK. They could do something similar depending on how talks with carrier are going per country.
Hopefully this would be a US thing only so our overpriced European iPhone would at least be superior to justify the price /s
Overall I believe that eSIM is a mess.
Currently there are two potential pros. The first one is for travel eSIM. You get at the airport, pay your eSIM, scan a QR code and voilà you are ready to go. Another benefit I could see is that the moment you subscribe online you can instantly use your cell plan, no need to wait to get your SIM card delivered. But it’s not even the case as carriers need couple days to activate your line, at least in France. As a solution one these carriers give a temporary number but it’s really not ideal.
And that’s about it for the pros while there are many cons. As other have said, anytime you have to do anything with your eSIM you’ll have to deal with carrier and eventually pay for it. It’s a mess to change your eSIM from iOS to Android and it’s even a mess to change it from an iPhone to another as your eSIM is on the device and not on ICloud.
So overall for now eSIM for a long-term line sucks while it’s fine for a temporary one (but not very privacy respectful).
I tried eSIM once, it was super difficult to understand how to set it up, even as a tech adverse person. Couple months later my phone died because of some water on the FaceID sensor. It was a great day, I was both furious that some drops of water killed my $1000 iPhone and I lost my eSIM the same day
IMHO eSIM can be the future and has to take over physical SIM at some point but it will only happen when they reach feature parity between SIM and eSIM + sell prepaid private eSIM + eSIM working on all devices + eSIM working the moment you pay for it