I like to think the use of the word pussy in this context is a contraction of the word pusillanimous which means lacking courage or resolution; cowardly; faint-hearted; timid.

http://www.dictionary.com/browse/pusillanimous?s=t