I have read the Wikipedia page on the topic, and the answers on this post focusing solely on $L^1$. The integral definitions are very clear, and the fact that $L^2$ has a natural norm induced by the scalar product, which is important in Fourier tranforms, and other bits of knowledge around these definitions, still leave me wanting for a couple of plots of functions, one for each space, as well as a short definition in English, even if only approximate.
To some degree, and leaving aside measure theory, which would likely have pre-empted this post to begin with, the absolute value of the functions may seem to serve a similar purpose to squaring. Yet, these are completely separate spaces.
If it wasn't clear enough from the tone of my answer, or my self-deprecating profile, I have no formal training in mathematics, so I'm looking for answers along the vein of the notable Terry Tao's explanation here:
I’ll start today with my article on “Function spaces“. Just as the analysis of numerical quantities relies heavily on the concept of magnitude or absolute value to measure the size of such quantities, or the extent to which two such quantities are close to each other, the analysis of functions relies on the concept of a norm to measure various “sizes” of such functions, as well as the extent to which two functions resemble to each other. But while numbers mainly have just one notion of magnitude (not counting the $p$-adic valuations, which are of importance in number theory), functions have a wide variety of such magnitudes, such as “height” ($L^\infty$ or $C^0$ norm), “mass” ($L^1$ norm), “mean square” or “energy” ($L^2$ or $H^1$ norms), “slope” (Lipschitz or $C^1$ norms), and so forth. In modern mathematics, we use the framework of function spaces to understand the properties of functions and their magnitudes; they provide a precise and rigorous way to formalise such “fuzzy” notions as a function being tall, thin, flat, smooth, oscillating, etc.
Evidently my question here is a bit more concrete, but not far off from what Professor Tao is addressing in the most natural, uncondescending and didactic way to capture as broad a segment of his blog's readers as possible. Clearly he is not talking at the audience, seeking acclaim from the initiated, but rather communicating effectively.
The first $1/2$ of the answer I am looking for would be this motivation for $L^2$:
Roughly speaking, $L^2$ space is the only functional space among $L^p$ spaces which is a Hilbert space, i.e. it has an inner product (and also complete)! One can imagine this spaces as a generalization of $\mathbb R^n$ to infinite dimensional cases. So many trends like finding minimum/maximum of function from $\mathbb R^n$ to $\mathbb R$ can be generalized to these spaces in a similar way...
But I am looking for more motivation behind the comment, "$L^1$ and $L^2$ are not "completely separate", in that $L^1 \cap L^2$ is a "very large" set."
Is $\{L^1\} > \{L^2\}$? How much bigger (or smaller)? What does it mean that the former measures the mean, while them latter, the energy? Etc.
There is this post in the Physics SE, also delving into $L^2,$ but again, not making an intuitive comparison with $L^1.$