apparently, it is not possible to associate a different ringtone for each SIM in dual phones.
This feature is instead allowed by stock SMS app in Android 11.
It is a needed feature for dual SIM phones