Is it really necessary to go that deep in order to be effective? I mean, some stacks consist of scripts running on interpreters in a VM somewhere.
But yes, learning about memory, how databases do indexing, how networks work (https://letterstoanewdeveloper.com/2019/10/11/learn-a-little... covers a bit of this), how assembly works (even at a high level)--these will all be helpful at understanding how systems work together and can break.