With my current carrier, switching physical SIMs does not activate the phone on the service. I have to use an app. Perhaps this is because I use an MVNO? eSIMs make this easier.
I had no problem swapping SIMs for basic phone service in the pre-smartphone era.
With a physical SIM, they can't stop you putting it into another phone, and there are no good technical reasons why you shouldn't be able to swap a SIM into a compatible phone and have it work immediately. That's how it's worked in many countries since GSM came out in the 90s.
With eSIMs, you may need to contact the carrier to transfer the SIM to a new device. This is a contact point with the carrier - and one where they can add barriers or fees.
For example, I use AT&T and before eSIM I could transfer my physical SIM between phones without calling AT&T. Now, with eSIM I can still transfer my eSIM between phones without calling AT&T so nothing has really changed.
If there were some way to pre-transfer the eSIM and only activate it if needed, it might be a different story.
It really does depend on carrier policy I would say
Still need WiFi, but that's not usually a nightmare. Glad I don't like traveling in the boonies, though.