He is a political pundit who was trying to rebut a (now) common political myth. The fact he parroted it back in an article a decade or two later doesn't mean it was the policy of the executive branch or any economist.
Which is entirely the point.
[1] https://www.washingtonpost.com/archive/opinions/1981/11/22/w...
I will say that there's a big myth that the US has been on some big market-oriented supply-side binge since the 1980s which is a giant myth in itself. The size of western governments, everywhere, has exploded since the 1970s... even if the tax rate hasn't.
Sowell would be just as critical of any policy directly benefiting the wealthy as well. He sees the far bigger problem as the countless "well-intentioned policies" intended (or at least sold) to help the poor/middle class that back fire, do nothing, or more often creates highly inefficient systems where only the politically connected get social benefits.
I highly recommend his book "Wealth, poverty, and politics" [1]. It'd do a 100x better job than me at explaining his general worldview, which is closest to mine. And it's hardly just lower taxes for upper/middle and keep the rest of the political machine the same (which is probably worst of both worlds IMO).
[1] https://www.amazon.com/Wealth-Poverty-Politics-Thomas-Sowell...
I think it's important to consider that Reagan's budget director, David Stockman, was quoted in the Atlantic as saying "It's kind of hard to sell 'trickle down,' so the supply-side formula was the only way to get a tax policy that was really 'trickle down.' Supply-side is 'trickle-down' theory."
IMO the goal of taxation as a system is not just to maximize tax revenue -- although that's an important component -- and lowering marginal rates may do that. It's also about ensuring fairness and mitigating some amount of wealth inequality. Just because a tax policy increases revenues by lowering marginal rates doesn't mean that "trickle down/supply-side economics is working" -- compared to, for instance, a wealth tax. The treatise focuses on the A vs. B of lowering vs. not lowering top taxes as the defining factor of trickle-down, but it misses the forest for the trees. Other solutions exist which may yield better outcomes for all.
The component I found particularly weak in the treatise was "if we don't lower their tax rate the rich will keep hiding money in tax-free muni bonds" and left it at that, and threw their hand up. Great, tax those. Or all holdings. Then we can pick up where we left off.