No, it's not a common type of story. Such a story with this specific topic is rather niche and might be considered inappropriate or too private for general discussion.
I'm not sure specifically which 'wife dildo story' you are referring to. There could be many fictional or personal accounts with such a title. It might be a made - up story in a certain adult - themed context, but without more details, it's hard to say exactly.
It can be appropriate in certain creative and consensual adult spaces. For example, in erotica writing where the readers are aware of and interested in sexual - themed stories. However, in mainstream literature or in places where there are moral and ethical boundaries regarding sexual content, it would not be appropriate.
There isn't really a well - known 'wife cock story' in mainstream literature or folklore as the phrase is rather ambiguous. However, if we consider the 'wife and the rooster' idea, in some rural folktales there might be stories where the wife's relationship with the farm animals, like a rooster, plays a role. But it's not something that is globally famous.
In a more serious - toned story, a wife who has felt unfulfilled sexually in her marriage discovers a big dildo. She uses it to understand her own body better. As she becomes more in tune with herself, she gains the confidence to communicate to her husband that their sex life needs some changes. She shows him the dildo as a way of starting the conversation about trying new things and being more adventurous in the bedroom.