I used to be married to a Catholic. We never had kids, but we tried for a while, so we had some discussions about them and I read about and reflected on Catholic baptism. I eventually came to the decision that my conscience would not allow me to have any part in the baptism of any child of mine.
The rationale for infant baptism in the Catechism is something close in effect to "we can't be sure that unbaptized infants go to Hell if they die, so better get it done to be on the safe side."
Another way of putting it: "when you're born, your child is such a reprehensible little ball of evil that it's possible - not certain, but possible - that a perfectly wise, perfectly good God might decide to torture him forever because of how evil he is, so we'd better splash water on him in a special way to erase that evil."
The splashing water part is just silly, IMO, but there was no way I'd stand up in front of my friends and family and nod in agreement with the idea that my innocent newborn baby is evil at all.