My guess is Mr. Johnson will resign after this year and the next President of the club will invite a woman to join - a very carefully selected woman who won't push anything. Then this whole controversy will die.
If I were a shareholder in a corporation, and saw that the CEO had insisted "on principle" to sponsor someone or something that brought disrepute on the company, and caused me to lose money, I'd want him fired.
I don't invest to lose money on some quixotic statement against feminism, etc.