I think it's similar with computers and programs. The essence of a computer is information, so the main skill a common person needs is knowing how to work with information e.g. in the present day, navigate the web safely, how to research appropriately + identify reliable sources, organize and analyze data, manage privacy, etc They shouldn't have to be programmers themselves, and indeed, that's the whole point of software, so that a common person can focus on their main task of working with information, and not have to be concerned about technical details under the hood.
note: things like excel macros where a software has a programming-like feature is a different matter, since it's a feature exposed explicitly by the software for users to exploit if need be. In any case, it's a software choice and hence specific only to that software.