I still prefer a physical SIM for my main cell plan, but when travelling to other countries it is so amazing to be able to just download an eSIM and avoid roaming fees. Airalo is quite convenient, but I hear it’s getting pricey compared to other options.
Plus with dual SIM I can disable roaming on my main SIM but still receive texts for free, but use data for cheap with the local eSIM at the same time.
Disclaimer: I live in Canada which has some of the most expensive cell plans in the world. Roaming in the US is $13 CAD/day and $16 CAD/day in the rest of the world. That seems like blatant extortion to me, they can’t blame Canada’s large size for expensive roaming fees (right?). I think US plans are a lot better, and I assume European cell plans are generally even cheaper.
Edit: I prefer physical SIMs for my main plan because if my main phone is dead or broken, I can just pop the physical SIM in an old phone that I bring while travelling. Until eSIMs can be somehow transferred like that, I don’t see myself using them for my main cell plan. Just remember to set a SIM PIN so that if someone steals your phone, they can’t use your SIM card to receive 2FA texts.
Edit 2: eSIMs are generally a pain to transfer between phones. I think my cell provider lets you do it online by scanning a QR code, but I know some make you call them and read 16 digit codes over the phone. Some even charge a small fee. I dread the day where other cell phone manufacturers follow what Apple did in the US (I think?) and make eSIMs the only option.