An SSD drive is very likely to sound better than a hard drive. But a high quality streamer will gather the music off the hard drive and shut it down when playing.
With a high quality streamer there should be no difference in sound quality between a streaming service like Qobuz and using music from your internal SSD drive. So if you have a high quality streamer I would not put a lot of effort / cost into internal memory. Less and less are ripped or downloaded music used at all. I only have some on my streamer for emergencies when the internet is down… at this point less than once a year for a very short time.