IcedPurple, Yes, he benefitted in the way you describe. But this is surely no different to what happens today in similar circles, people wanting influence, networking, putting this person in contact with that person? The use of quite vulnerable young women as part of that is objectionable, yes.
Part of Ward's tragedy was that he was quite socially precarious himself. In one of the episodes (forget which) there's a conversation in which it is revealed that he "only" attended a minor public school (while Lord Astor, Profumo himself, etc etc had all been to Eton, Harrow, etc.) That difference would have been very significant in that circle. Ward is a social climber, loves seeing himself as the friend of aristocrats, Cabinet ministers, etc and doesn't realize until nearly the end how superficial and basically unpleasant most of them are. Astor giving him a cheque for legal fees and then, straight after, telling him to return the keys to the cottage at Cliveden, even requesting that Ward write a letter implying that that is Ward's own choice! And then scuttling away abroad just before the trial. The men at the Athenaeum Club who, once they have heard that Astor has gone, couldn't give a shit about someone who has almost certainly been fitted up. And so on. These people were users and Ward, naively, didn't understand that.
As for "charming", that can be taken in two ways.
And let's not forget that members of the Royal Family were also caught up in this. (That scene when W. walks round the exhibition of his drawings and sees that the portraits of Princess Marina, Prince Philip and Princess Margaret have been mysteriously removed.) People who had clearly been happy to have contact with Ward when it suited them.
Also, I don't think it's been mentioned anywhere in the dialogue but it was widely understood by the Press that Prince Philip had at some time (probably in the 50s) had an ex-marital affair with Valerie Hobbs, John Profumo's wife. There was a "gentlemen's agreement" not to publish anything.