Otoh: very possible their work produced spin-offs that were useful in other fields (math advances, thought experiments, practical research tools & equipment, people in other fields having a look at their work from a different angle, etc)
AND having bright people chew on a subject for decades & come up (mostly) empty, is a good hint there's nothing there. 'Unknown' vs. 'we've tried hard & not found much' is a useful result by itself. Think of it as reducing the search space.
Personally I know many people who abandoned Physics to reinvent themselves as data scientists. Good for them that they were able to re-purpose their training; that doesn’t mean physics training is the best way to become a data scientist. My bias is that quantitative social science is a better route, although some of what it gains from focusing on people is often lost through less rigorous mathematics and software development requirements.