I have no idea where this idea would come from. I have scars from breast enhancement, caesarean section and other surgeries. My SO has had multiple shoulder surgeries (two on each), two knee surgeries, and a variety of injury scars on his back, arms, etc (e.g. scars from fights, knife wounds, etc). No one has ever said anything about them.
I honestly would be floored if someone would be turned off by scars. Maybe, just maybe, a younger couple (in their 20's for example) who hasn't lived may be surprised by scars but even that seems far fetched.
Be proud, be confident. I've never had anyone complain about my caesarean scar while I rode them. 😀