I think you’re unnecessarily worried about this. If you don’t trust your carrier to get this process right, perhaps it’s worth choosing a different carrier.
Do you know a carrier which you have any leverage against? I don't. Better get a physical SIM.
Oh, you do? It's still a single point of failure. Customer support servers down? Should have gotten a physical SIM.
Unbeatable servers? Good luck swapping eSIMs when you want to sell/throw away your phone abroad, out of range of internet. Should have gotten a phyical one.
Never out of range? Wonder what you do when your phone breaks and you have no one to babysit you through the process. Should have gotten physical.
Etc.
That's what an additional sigle point of failure means: less control over your own infrastructure.
My carrier is currently not doing eSIM. Also some low cost carriers can’t be contacted in any other way than a chat. Which is a problem in many real world situations if you need an eSIM asap. Sometimes there is no one in the chat available at all.
If your carrier doesn’t support eSIM, then this discussion doesn’t apply to you. Carriers aren’t going to make eSIM available until they have the support structure available to make it useful to customers.