Eh, I would notice the association, but I don't think it is the end of the world. It would probably deter me from using the name, though.
I know who the artist is and he is well known, but not everyone knows who he is. I don't see him as staying around that long, but then again, I haven't heard anything from him since he did "Your body is a wonderland" or whatever it was. Many artists fade in time.
If you don't have any other names that you love just as much or you think you would regret not using it, then use it. You could always use John/Jonathan as a middle name.