Theoretically. I reality, you may have an esim that can only be activated once. Then you need to have another QR code from the providers local shop to activate another esim for your phone number. You just will know it, if you try it and - mostly fail.
A real SIM just works as a SIM - until kaputt. I am not against esim at all. I would love to see working them the way physical SIM do.
Real case: We do have a somewhat extraordinary situation at the moment. I do own an esim witch is blocked on an old phone until I do show up in a a shop of my provider. Unfortunately blocked outside my home country due to travel restrictions.
Oh you mean two eSIM from same provider? What you are describing seems to be carrier specific. But it is indeed worst experience than just SIM.