Chomsky also wrote about the mechanical philosophy and the limits to science and understanding:
https://chomsky.info/201401__/
What Desmet points out in his book is that the greatest scientists and intellectuals are more humble and less dogmatic. In Sheldrake's TED talk, there is a need to rethink about what science is but that's a long stretch because the universities are mostly indoctrination camps. Another book to read is Jeff Schmidt's 'Disciplined Minds: A Critical Look at Salaried Professionals and the Soul-battering System That Shapes Their Lives'.
Robert Laughlin - Is Emergence Fundamental?
https://youtu.be/qT9iDcajqMo