Compare it to the 'do no harm' in medicine: say a doctor kills a healthy patient, so that his organs can save five others. At first, many lives are saved, but when this becomes widespread, how long until no-one dares come near a hospital? Or how likely is a patient to admit to having suicidal thoughts, if it results in police going through their private home, confiscating guns, or even committing them for their own good?
Absolutist, 'ideological' positions such as do no harm, and doctor/lawyer-patient/client confidentiality, are important guards against unwanted second-order effects.
Other provisions are less loosey-goosey. The first and second amendments are categorical prohibitions. You can’t establish a national religion even if you think the results will be tremendously beneficial. The taxation clause is similarly clear. We needed an amendment to create the income tax, even though it was necessary to a modern state.
I'll never understand how a significant amount of the population can entertain the idea that "gun rights" are central to liberty, or that unlimited liberty above long term survival of the species is somehow desirable.