The problem I can see with the one-SIM-per-profile setup is that whichever profile is not active will not receive any calls/messages. It will need to be switched over to get anything, but then that turns off the other one (so to speak). Unless I am missing something. I want to have both active at the same time.
I also have two numbers - one personal, one professional - so maybe my work-around setup could help you.
For redundancy, I also make sure these are two different network providers, one for each SIM. I manage this with a physical SIM for one, and an eSIM for the other (I have a 6a).
I work having both personal and professional going at the same time it by having a sentinel character in the Contact entry of a professional contact. This indicates to me that it needs to be used in conjunction with the "professional" SIM. I also change the colour associated with the SIM (in Settings | Network & Internet | SIMs) by choosing the SIM, and editing its name and colour - the name contains the network provider and phone number).
One of these providers has a data time-out per month (the other one banks it up to some very large amount), so I choose that one as the primary mobile data provider, but also set the toggle so that data will switch over to whichever is the stronger/better signal. I usually don't get through the monthly amount, but there you have it.
The colour code then tells me (when the phone rings) which number is calling, and thus whether it is personal or professional. Sadly, at present it does not appear to be possible to set a different ringtone for each SIM/number - that would be handy.
I also have two instances of Signal running, one for each number (or, more precisely, Signal for one, Molly for the other). Each of these is linked to Signal and Signal Beta on multiple computers.
And, when I don't want any work calls, I turn off the prof SIM (and mute the Signal instance for the prof context).
It's not pretty, but it's a handy kludge that works for me. YMMV. ;-)