It will depend on the person, but I think generally speaking, a song is but one aspect of an artist / the art of music; if you're a mass consumer that just has something playing in the background, it probably doesn't make a jot of difference (consider also "muzak" / elevator music), but if you're more of an active listener you may look into and enjoy the story behind the music and the artist as well.

Personally I think knowing the story behind music makes it better. The music isn't to everyone's taste, but for example Devin Townsend's wiki page / story is a trip: https://en.wikipedia.org/wiki/Devin_Townsend