No it is not sin. There is a twofold purpose for sex. 1) procreation; and 2) to bond in unity the husband and wife.
2360 Sexuality is ordered to the conjugal love of man and woman. In marriage the physical intimacy of the spouses becomes a sign and pledge of spiritual communion. Marriage bonds between baptized persons are sanctified by the sacrament.
2361 "Sexuality, by means of which man and woman give themselves to one another through the acts which are proper and exclusive to spouses, is not something simply biological, but concerns the innermost being of the human person as such. It is realized in a truly human way only if it is an integral part of the love by which a man and woman commit themselves totally to one another until death."
Tobias got out of bed and said to Sarah, "Sister, get up, and let us pray and implore our Lord that he grant us mercy and safety." So she got up, and they began to pray and implore that they might be kept safe. Tobias began by saying, "Blessed are you, O God of our fathers. . . . You made Adam, and for him you made his wife Eve as a helper and support. From the two of them the race of mankind has sprung. You said, 'It is not good that the man should be alone; let us make a helper for him like himself.' I now am taking this kinswoman of mine, not because of lust, but with sincerity. Grant that she and I may find mercy and that we may grow old together." And they both said, "Amen, Amen." Then they went to sleep for the night. (Tob 8:4-9)
2362 "The acts in marriage by which the intimate and chaste union of the spouses takes place are noble and honorable; the truly human performance of these acts fosters the self-giving they signify and enriches the spouses in joy and gratitude." Sexuality is a source of joy and pleasure:
The Creator himself . . . established that in the [generative] function, spouses should experience pleasure and enjoyment of body and spirit. Therefore, the spouses do nothing evil in seeking this pleasure and enjoyment. They accept what the Creator has intended for them. At the same time, spouses should know how to keep themselves within the limits of just moderation.
2363 The spouses' union achieves the twofold end of marriage: the good of the spouses themselves and the transmission of life. (my emphasis) These two meanings or values of marriage cannot be separated without altering the couple's spiritual life and compromising the goods of marriage and the future of the family.
The conjugal love of man and woman thus stands under the twofold obligation of fidelity and fecundity.
You must always be open to life, but within that virtue you can enjoy sexual uinion with your spouse.