I'm trying to learn some maths on my own, and this is a reach, but I'm hoping for a reader's digest explanation.
I have an idea of the need for a measure to be defined on sets, yet the definition of Lebesgue spaces on Wikipedia (if related at all) starts off with sequences and functions. Does it have anything to do, for instance with $\sigma$-algebras? Is it a solution to a problem at the crossroads of probability and topology? Where is it framed within the branches of mathematics? And what are the meanings of $\mathcal L^p$ and $\ell^p$ (the answers here being too advanced)?

You cannot expect to learn measure theory by asking a question online.
The basic idea is that one wants to define a notion of integration that is better than Riemann's. Instead of subdividing the domain of the function, one subdivides the codomain. An integral is "limit of sum of value of the function times size of the region". If $f$ maps into $[0,1]$, say, this leads to $$\tag1 \lim_n\sum_{j=1}^n \frac jn\,\operatorname{size of}(f^{-1}([\frac {j-1}n,\frac jn]). $$ To make sense of $(1)$ one needs to make sense of "size of". That is, we need a measure on the domain of $f$. The spirit is that on the real line $m([a,b])=b-a$, but one wants to extend this to arbitrary subsets.
The problem is that one can prove that it is impossible to define such a measure on all subsets of $\mathbb R$. But also one can prove that a big enough $\sigma$-algebra exists where it can be done.
A second problem, now that one assumes that not every subset of the domain will be measurable, is that $(1)$ requires that preimages of intervals are measurable. Such functions, those such that preimages of open sets are measurable, and the measurable functions.
In the end, one gets that $(1)$ defines a notion of integral for functions whenever the domain admits a $\sigma$-algebra and a measure on it.
Given $1\leq p<\infty$ a measure space $X$ (which comes together with a $\sigma$-algebra and a measure $\mu$ on it), the corresponding $L^p$ space is a Banach space (complete normed vector space) given by those measurable functions $f$ such that $\int_X |f|^p\,d\mu<\infty$. The norm is $\|f\|_p=\left(\int_X|f|^p\,d\mu\right)^{1/p}$. There is also $L^\infty(X)$, which a different definition.
It takes more than a month in an advanced math class (fourth year/graduate in North America) to do the above.