A quick follow-up to close out this topic.
My ROCK setup is now up and running. Database successfully restored from the Synology Core and music is now syncing from the NAS to the internal storage I installed in the NUC via rsync as described in this very helpful post: Roon ROCK Synology rsync setup
Thank you all for your input here in this thread.