The wave function is a mathematical model describing how we think waves 'moves'. It's about what 'states' a wave can be in before it interacts with a detector/observer.

There are two 'main' camps as I see it. Either you trust in that at some point a wave function collapse through its interaction with a 'observer' (and why we use a 'observer', is the idea that to really 'know' that it stops being in a superposition someone has to be there to 'observe/measure' it. Although anything could be a 'observer/detector' it's only when we notice it that we can say it 'exist' and that is the approach taken as I understands it). and that's what I think of as the Copenhagen interpretation (Bohr) in where you don't discuss if the wave function is a 'real thing' in itself but only what, and how, a wave does. That is, how it finalize itself in a interaction, as described by the model, like that photon hitting your eye, interacting finalizing itself. And the way it is before interacting is undefined as per 'Heisenberg's uncertainty principle' which states that you can't, ever, know all there is needed to know about, well, anything in fact at the quantum level At least not enough to making you able to say how the particle really 'is', as well as what's going to happen. Instead you have to look at the probability of it, the photon being in a undefinable 'superposition' before interacting.

A superposition in this context means that the wave only can be defined by its probability of becoming, in fact not being able to be defined at all, and therefor also possible to view as it has all possibilities coexisting, as long as there is no 'interaction' finalizing it.

The other way is Feynman's in where the wave function becomes defined by all paths possible, with our wave taking them all simultaneously. But as the paths gets combined mathematically some of them will fall away due to their 'probability amplitudes' quenching each other or reinforcing each other and when you sum up the amplitudes of all the different paths (sum over histories) then the only path that survives will be the one that the particle actually follows.

It's two ways to the same end. Nowadays it seems that people finds Feynman's definition the easier to stomach, as it doesn't involve HUP (Heisenberg's uncertainty principle) as the Copenhagen interpretation does.

But to me 'sum over paths) is just as mysterious as it uses the idea that all paths somehow has to be taken for this to happen. Without those paths being taken for real, there is no 'probability amplitudes' to interfere with each other :) Not that I mind, I've always enjoyed magic :) or 'sleight of hands' if you like.

So if your son wants to become a fully practicing arcane master of the 'arts' :) he's made a head start asking about this. And you too :)