Any stupid jerk who says that would get his ash can kicked back to kindergarten by the women shooters in USPSA, and that includes rifle and shotgun. Generally speaking you want the largest frame gun in a caliber that you can manage, but that doesn't mean that a Kahr CW9 won't work for you at all.
And you don't 'thumb cock' revolvers, you shoot them double action like you are supposed to.