But there is an accessible video that explains electricity pretty well. Veritasium - The Big Misconception About Electricity: https://www.youtube.com/watch?v=bHIhgxav9LY
There is one commonly used concept that requires understanding electricity correctly, and not just as a combination of waterhoses and gizmos. It's impedance, and it directly corresponds to the "controversial" experiment that Veritasium is proposing in his video. Impedance breaks the pipe-of-electrons analogy.
You would have to start with alternating current water, since "DC" water maps to DC, where impedance =resistance.
Once you've got alternating water, you can add inductance (inertia) and capacitance (rubber diaphragm tanks) and I think it all works out.
It's just that we don't have a good intuition for alternating water current so it's not a very useful analogy in that case.
Sounds bizarre, right? That's why this is mostly ignored unless it can't be, for example in very fast circuits.
One way to look at this is that there is no such thing as a hose for electricity. It cannot be confined to a conductor, even if it is also wrapped by an insulator. It is only mostly confined. And this is not some failure of materials engineering that we may overcome one day, this is just how this stuff works.
BTW, the answer in the video is 1/c seconds, i.e. one meter worth of speed of light. And the lightbulb will experience current determined by the impedance of the transmission line. Then the fields will do a full wraparound the ends, at which point the circuit will start stabilizing around the resistance of the load. It can take a few back-and-forth iterations to stabilize the current.