This dual app stuff is great, but take note that this is only happening recently. Even stock Android doesn't support it yet. First implementation on MiUI was also quite buggy (eg. second whatsapp cannot be backed up to Google drive). Not all OEMs support this either (as far as I know, mostly just the Chinese OEMs and Samsung).I second that on multiple accounts.
Having 1 eSIM + 1 physical SIM or 2 physical SIMs doesn't really matter. What really matters is whether there is 'dual apps' function like the one on Xiaomi or Samsung phone. If possible, on top of 'dual apps', multiple users (aka 'User Profiles' on Android 5.0 on phone) should also be added (presumably in the use case of iPad in family).
In the case of Hong Kong, most Android phones here do have 2 physical SIM slots. What are they for? Well people here nowadays make very few phone calls. One of the prominent reasons is to use the 1st SIM as the main phone number + data plan, and the 2nd SIM card can be a pre-paid SIM card with higher data cap so if the 1st SIM is running out of data allowance, the 2nd SIM card can be the backup.
Another use case would be the 1st SIM is always in use for everything (phone call, data, SMS), and the 2nd SIM is just for receiving SMS for some phone number-specific applications like WhatsApp. For example, with dual apps on an Android phone, people can have one WhatsApp for personal use (with the 1st SIM number) and another WhatsApp for joining company / organisation WhatsApp groups for work-related purposes (with the 2nd SIM number). Even iPhone now comes with 'dual SIM' support, one cannot have 2 WhatsApp apps on an iPhone, thus having the need to carry a 2nd phone.
iPhone XS / XS Max / XR is crippled in this respect IMHO. It all comes down to iOS. So 2 things: dual apps and multiple users (especially in the use case of iPad).
Considering this is Apple's first time implementing some sort of dual SIM feature, I can give them leeway for not immediately came up with the same solutions as some Android OEMs. I bet if Apple wanted to allow the dual app feature, they want to make sure their iMessage stuff is ready to support it as well.