Contacts not appearing in People app when restoring from backup (aka switching from Xperia X to Xperia 10 II)

The following bug is a duplicate of this one:

I’m closing the other one so that any further discussion can continue here. However, worth noting is that there’s some useful material in the other thread on how to workaround the issue.