My take on this, as a pretty-much-retired professional sax player, is that in order to get the really big money in the arts one has to be prepared to shoulder the very onerous burden of fame - which of course has little or nothing to do with talent. The only exception to this is the musician who genuinely and honestly has elevated their art to the point where fame is unavoidable.I also think this as well, take the sax out of the song and it wouldn't have been so iconic, the sad thing was that Raphael Ravenscroft got a small fee for his work and Gerry Rafferty was getting £188,000 a year royalties out of the song.
Having played on pretty much every recording of a very famous British composer sine 1984, I am quite happy to have avoided the media attention that my employer attracted, which has made him utterly miserable. I do get PPL royalties, and they add to my bank balance, but in a modest way on the whole. Money is important, we must make enough to live comfortably, but beyond that I am happy to remain fairly anonymous and modestly solvent.