No, our science is no illusion. But an illusion it would be to suppose that what science cannot give us we can get elsewhere.
The Future of an Illusion (1927), in James Strachey (ed.), The Standard Edition of the Complete Psychological Works of Sigmund Freud (1961), vol. 21