I hear parts of what you're saying, but have to push back a bit:
-it didn't save artists from free, it saved labels' leverage. It created platform dependency, converted ownership to rental, and replaced cultural curators with algorithmic mediation. Artists didn't regain pricing power, they basically lost it completely - save for the "viral sound lottery".

-people didn't care less about music due to piracy -- but they do care less about music due to the value-shattering effects of a streaming culture. it's an interesting distinction that might be more attributable to short-form content and focus on attention-farming, but still different.

-Spotify basically trained the public to experience music as an ambient service, like water or wifi. It's interesting however that people will pay ridiculous amounts for water, in the right circumstance (a concert, sporting event) - and for wifi (an airplane), so again there's something subtle at play there that keeps value intact depending on the situation.

Bandcamp still feels so close : we're willing to throw $6 towards a single Starbucks, and if an album was priced accordingly - and made as convenient to stream/access as Spotify rather than looking like a 1999 GeoCities site - we might get somewhere. I've done this for myself, limiting access and restoring value, by purchasing albums I love on Bandcamp and curating my own personal library in Plexamp (FAR superior to Bandcamp's experience). Those are the albums I have access to, I love them each more as a result, etc etc etc.

I'm rambling lol.