I think there are not many mathematicians who really believe that a non-constructive proof is worthless.
One reason for this is that, generally speaking, non-constructive proofs can in fact be embedded into constructive logical systems. I think there is more controversy about what formal foundations we should endorse for mathematics. ZF(C) is good enough as a proof of concept, but type-theoretical and category-theoretical foundations seem to be better in terms of actually doing formalized mathematics in the real world.
I think there are not many mathematicians who really believe that a non-constructive proof is worthless.
One reason for this is that, generally speaking, non-constructive proofs can in fact be embedded into constructive logical systems.
While that may be a reasonable justification for what mathematicians do, I think it is false as a historical claim about what caused mathematicians to do what they did. Mathematicians settled on their foundations ("No one can expel us from Cantor's Paradise," 1926) before they understood power and limits of constructive methods.
I'm curious if you are making a practical claim or a formal one.
Half-closing my eyes and looking at the recent topic of morality from a distance, I am struck by the following trend.
In mathematics, there are no substantial controversies. (I am speaking of the present era in mathematics, since around the early 20th century. There were some before then, before it had been clearly worked out what was a proof and what was not.) There are few in physics, chemistry, molecular biology, astronomy. There are some but they are not the bulk of any of these subjects. Look at biology more generally, history, psychology, sociology, and controversy is a larger and larger part of the practice, in proportion to the distance of the subject from the possibility of reasonably conclusive experiments. Finally, politics and morality consist of nothing but controversy and always have done.
Curiously, participants in discussions of all of these subjects seem equally confident, regardless of the field's distance from experimental acquisition of reliable knowledge. What correlates with distance from objective knowledge is not uncertainty, but controversy. Across these fields (not necessarily within them), opinions are firmly held, independently of how well they can be supported. They are firmly defended and attacked in inverse proportion to that support. The less information there is about actual facts, the more scope there is for continuing the fight instead of changing one's mind. (So much for the Aumann agreement of Bayesian rationalists.)
Perhaps mathematicians and hard scientists are not more rational than others, but work in fields where it is easier to be rational. When they turn into crackpots outside their discipline, they were actually that irrational already, but have wandered into an area without safety rails.