While an SSD may be “ideal”, for a smaller collection it certainly isn’t required. I have about 745 albums and a Roon runs perfectly fine on my Salkstream III, which doesn’t have an SSD.
There’s a good post here that gets into more detail about recommend hardware