OED gives at the very least two distinctive senses for this phrase. That of female genitalia is attested as early as 1699, but it is not considered for your sense indicating "coward". The opposite a single, which I duplicate under, may be the purported supply of pussyThe foundation pusillus that means really little might be an amplification of pusu