It was not until the 1970s and the Lucasian rationalist critique that microfoundations became an important inquiry. And that shift didn't occur because people were sentimentally attached to micro (if anything, they were attached to prevailing macro theories), it happened because Lucasian rationalism explained an empirical phenomenon (a shift in the Phillips curve) that was not explained by the other approaches. Since that time support for microfoundations has waxed and waned a few times, in response to several other empirical shifts.
In practice, economics is much like the other sciences, with a slightly wider diversity of thought. Like the other sciences, most people only understand a caricature of it that is given through the lens of politics. Unlike the other sciences, more people seem inclined to accept this caricature and criticize it on that basis, which is unfortunate.
[1] Everyone, but see https://www.jstor.org/stable/2231707?seq=1#page_scan_tab_con... for a plausibly-readable overview