What motivates a woman to explore cuckoldry varies according to the woman. For example, the connection I experience with my cuckold appeals to me more than anything sexual that may come of it. In fact, I would not cuckold someone unless I had a strong emotional bond with them.
For some, it is a fetish where they focus primarily on the sexual aspects of the relationship.