From what i could glean from the number who attended his funeral (as you say, just 9), this probably didn't have anything to do with the 'rent' boy' incident. The man disliked nearly everyone he met - apart from gay sailors, apparently - and refused to give autographs, ripping the autograph hunter's paper up instead. He didn't particularly get on with the rest of the Carry On crew and was, according to all reports, a very difficult person to like.
Wonder if those who did attend the funeral did so out of a sense of duty, rather than respect?