I recently came across this question in the context of a course on functional analysis. This question was posed by a friend of mine, and the Wikipedia pages and existing MO threads are too dense for me to understand. Some SE threads we've looked at include this, this, and this - I feel none of these really answer the essence behind our question (the last one comes close but only briefly touches on the question here).
It is a basic result that separable Hilbert spaces are characterised by the existence of a countable basis, from which we can see that any (infinite-dimensional) separable Hilbert space is isometrically isomorphic to $\ell^2$. What we are wondering is why this result is helpful - we have tried to explain the build up to that below.
Classical PDE systems assume that the defining equations are smooth, but it turns out that this is a really strong condition to enforce (for example, take a square wave in the wave equation). By relaxing this assumption, there are certain measure theoretic issues that we run into, and so we instead have to consider the equations in their equivalence classes (e.g. in $L^2$, where for example the square wave is differentiable almost everywhere). In particular, the subspaces that these solutions live in are called Sobolev spaces, which are themselves Hilbert spaces.
It turns out that for some values of $p$, the Sobolev spaces are also separable, and so all the results from functional analysis can be applied to show existence and uniqueness of solutions to these linear PDEs. Additionally, it turns out that the same thing works for non-integral $p$ (Bessel spaces) which are also Hilbert space when $p = 2$.
The specific question that we still don't have a good answer to is
Why do we care about separable Hilbert spaces being equivalent to $\ell^2$? What property of $\ell^2$ makes it so useful in solving systems of PDEs?
It appears that the square summable sequences look similar to the Fourier series which are used to define Sobolev spaces, but this link is not made clear anywhere that we can find. In addition, even with such a link, we are unable to find an explanation for why/how this allows us to solve certain systems of PDEs.
A good answer for this would be one which explains this link and motivation (to a background strong in algebra and Riemannian geometry and understanding graduate-level functional analysis and measure theory, but with a much more elementary foundation of PDEs), or otherwise recommends some light, introductory resources and a short summary of what is really going on here.