The story
A more elaborate form of nervous as a cat. The implication is that the cat is afraid of its long tail being caught underneath a rocking chair.
Etymology from Wiktionary, CC BY-SA 4.0.
nervous as a long-tailed cat in a room full of rocking chairs
Today it means: Extremely nervous. Full definition →