Hi Wendy,
It's all about context. There are a lot of words in French (as in English) which have sexual connotations. It is however in the eye (or ear) of the beholder .
There is absolutely nothing wrong with referring to your female cat as 'chatte'.
Hope this helps!