From my experience, newbie users are generally more interested in the end result: Their intended packages are working, and what that package is doing. They are not yet interested in all the libraries required and whatnot.

As they get familiar with their systems, they get interested in what makes the particular package or software tick. Then, the digging starts. At that point they are already pretty proficient with their package managers, and start to learn their systems inside out. At that point they're not beginners since they can do targeted tinkering.

Except very rare circumstances, I didn't see anyone to dive to the deep end directly.

I guess sou just have a weird definition of "what a software does" means. Because to it is exactly about the end product.