Of course for some they are horrified by the prospect of some of the women who might comprise half the genes of their babies, or what those babies will end up like... but in the long run a random 50% of your genes survive in each one. Have several and you'll cover your whole genome. And most likely in a few centuries nobody will know or care what their personalities were like or even what their lives were like... but your genes will live on. (And if you had male line descendants, and they had males etc... your Y DNA will go on to long outlast your autosomal DNA, which gets split in half each generation until eventually it whittles down to random noise... but your Y DNA remains almost unchanged for thousands of years. But that's another story.)
Of course for some they are horrified by the prospect of some of the women who might comprise half the genes of their babies, or what those babies will end up like... but in the long run a random 50% of your genes survive in each one. Have several and you'll cover your whole genome. And most likely in a few centuries nobody will know or care what their personalities were like or even what their lives were like... but your genes will live on. (And if you had male line descendants, and they had males etc... your Y DNA will go on to long outlast your autosomal DNA, which gets split in half each generation until eventually it whittles down to random noise... but your Y DNA remains almost unchanged for thousands of years. But that's another story.)