Not everyone who drives a car needs to be able to rebuild the engine.
Not everyone who writes a video game needs to write the physics engine.
Not everyone who needs to analyze a dataset needs to write SQL.
Abstractions and tools exist at levels that provide value to people solving problems. The more accessible the tools are, the wider the net of people that can leverage them.
A minority of voices can loudly yell in a corner about how everyone needs to use modal editors and write their own assembly while the rest of the world moves on and ignores them.