I actually do think this is a legitimate concern, but at the same time I feel like when higher-level languages were introduced people likely experienced a similar dilemma: you just let the compiler generate the code for you without actually knowing what you're running on the CPU?

Definitely something to tread carefully with, but it's also likely an inevitable aspect of progressing software development capabilities.