Kids are definitely a net positive for society. They're future taxpayers.
But that's not relevant to couples choice to get pregnant. I've never heard a parent say they had kids so they can pay into Social Security.