There are a set of secular myths that have invaded some Catholic minds on this topic, and on the general topic of death.

These Catholics fail to remember that death and decay are natural realities, and therefore are marvelous things that God gives us to sanctify, to make holy, with the powers He has granted us through the Sacraments, our Baptism, Confirmation, Marriage, Holy Eucharist, and Confession!

One myth is that our dignity is somehow related to the proper functioning of our organs.    Not so.

Another myth is that all pain is evil.  Not so.  Pain too can be sanctified and "dealt with" properly with prudence, temperance, and the use of our intellect (which includes the proper seeking of palliative aids, as the Church beautifully teaches).