Dunno if there's any clear numbers on rates of depression/suicides or reported feelings on childlessness. But if I were to guess it probably effects women more than men. If a man at least has a hot girlfriend or gets lots of good sex from multiple attractive women he'd at least be able to cope that way. Harder for women I assume to deal the void.

Pic related is suicide in elderly people by childlessness and having children. Couldn't find anything else apart from this. I'm sure there's things like having kids but zero support in old age, or elderly not having kids but lots of support.