The fact that most people don’t understand how things work is a testament to good design. You shouldn’t have to understand how a car works to use a car. You shouldn’t have to understand how a lightbulb works to switch on the lights. Abstraction allows us to build on prior technologies.
It’s also a practical reality of living in a complex world. Someone using Excel isn’t thinking about how that app was programmed. Most computer programmers don’t have in-depth knowledge of how a CPU works. And they definitely don’t understand the chemistry of a transistor.
The fact is we live in a world too complex to understand it all. That’s not necessarily a bad thing.