The tournament director of one of tennis' most prestigious events has resigned after saying that female players should get "down every night on" their knees to thank some of their male counterparts.