Is women's club the correct example of the singular possessive case?

Yes, the noun women's is the possessive form of the pluralnoun women.

The women's club = the club of the women.