Fwiw there's a flag in ios settings somewhere that lets you also sync sms to icloud.

Settings > Messages > Text Message Forwarding.

You may have to enable syncing on the messaging app on macos as well