There are many Japanese stories that could fit this. For example, some traditional Japanese folktales might feature interesting wives. One could look into the works of famous Japanese authors like Murasaki Shikibu. Her 'The Tale of Genji' has many complex female characters, though not directly 'horny' in the modern sense. But it gives great insights into the roles and personalities of wives in that era.
Another option is to explore Japanese dramas based on stories. They often come with subtitles. Some family - centered dramas depict the lives of married women in different ways. These can be a great source to find stories about wives that are engaging and full of cultural nuances.