If you have it set up as cache than it is just that, a cache, and you can’t (explicitly) move anything to it. Synology will pull everything frequently accessed in there itself though. If you have it set up as a regular storage volume, then yes, you may want to move Roon’s database there.
Note: to get full benefit of a read AND write cacheing, you need 2 sticks.