I created a small piece trying to build intuition, my approach was to think of it as probing with test signals, so instead of recreating a waveform, it's more poking at it with sines and seeing how well the test sine matches the target signal.

https://dsego.github.io/demystifying-fourier/