There was a time where computers weren't as fast and libraries were not as high-level/user friendly, and you required to know these things in order to get things done.

Today, unless you are doing things at scale (tiny fraction of startups), you don't need to know how to make things run in the most optimized way possible.