How should we think about Spherical Harmonics?
In short: In the same way that you think about plane waves.
Spherical harmonics (just like plane waves) are basic, essential tools. As such, they are used over a very wide variety of contexts, and each of those contexts will end up using a different "way to think" about the tools: using different properties of the tool, putting it in different frameworks, and so on.
In that regard, "how we should think" about the tool depends on what we want to do with it and what we already know about the context. This is ultimately a personal question that is up to you, and you haven't really given us much to go on to say anything useful.
That said, you seem to be confused about the relationship between the statements
-
spherical harmonics are eigenfunctions of the angular momentum
and
-
spherical harmonics form a basis for the functions over the sphere.
As I said above, you should think of these in the same way that you think of plane waves, for which the two statements above have direct analogues:
-
plane waves are eigenfunctions of the linear momentum
and
-
plane waves form a basis for the functions over the line,
in the more specific senses that
- the plane wave $e^{ikx}$ is an eigenfunction of $\hat p = -i\hbar \frac{\partial}{\partial x}$ with eigenvalue $k$
and
- every function $f(x)$ over real $x$ can be expressed as a superposition of plane waves, by means of its Fourier transform: $f(x) = \int_{-\infty}^\infty \tilde f(k) e^{ikx} \mathrm dk$.
So: which of these two properties is more important? it depends! it depends on what you're doing and what you care about. Maybe you need to combine the two on equal footings, maybe you need to put more weight on one or the other.
Can you forget about the second statement and just focus on the eigenfunction properties? maybe! it depends on what you're doing and what you care about. If you continue analyzing the problem, both properties will come into play eventually, but where and when depends on the path you take.
(As a rule of thumb, if a statement is unclear and it is not being actively used in the context you're in, then: yes, it is probably safe to put a pin on it and move on, and to return to understanding what it means and why it holds only when you run into it being actively used. In many cases, actually seeing it used in practice is a massive help into understanding what it's for!)
In any case, though, the completeness properties can indeed seem a little mysterious. They've been handled quite well by the other answers, so I won't belabour that point. Instead, I will fill you in on a secret that very few textbooks will tell you: the spherical harmonics are all polynomials!
More specifically, they are polynomials of the Cartesian coordinates when the position $\mathbf r$ is restricted to the unit sphere. Once you take away all of the trigonometric complexity and so on, the $Y_l^m(\theta,\phi)$ become simple polynomials:
\begin{align}
Y_0^0(\mathbf r) & =
1
\\
Y_1^{\pm 1}(\mathbf r) & =
x\pm i y
\\
Y_1^0(\mathbf r) & =
z
\\
Y_2^{\pm 2}(\mathbf r) & =
(x\pm i y)^2
\\
Y_2^{\pm 1}(\mathbf r) & =
z (x\pm i y)
\\
Y_2^0(\mathbf r) & =
x^2+y^2-2 z^2
\end{align}
(where I've removed the pesky normalization constants).
The basic concept of building this family of polynomials is quite simple:
- Work your way up in degree, from constant to linear to quadratic to higher powers.
- Keep the whole set linearly independent.
- Within each degree, keep things as invariant as possible under rotations about the $z$ axis.
That last part might sound mysterious, but it should be relatively easy to see why it forces a preference for the combinations $x\pm iy$: if you rotate by an angle $\alpha$ in the $x,y$ plane, $(x\pm iy)$ transforms simply, to $e^{\pm i\alpha}(x\pm iy)$. If you're wondering, this is the feature that connects to the $Y_l^m$ being eigenfunctions of $\hat L_z$.
With that in place, it is fairly easy to see how the progression goes
$$
1,x\pm iy, z, (x\pm iy)^2, z(x\pm iy),\ldots
$$
... but then what's with the $x^2+y^2-2 z^2$ combination? The answer to that is that, in general, there are six separate quadratic monomials we need to include:
$$
x^2,y^2,z^2,xy,xz,yz.
\tag{*}
$$
We have already covered some of these in $(x\pm i y)^2 = x^2-y^2 \pm 2ixy$, and we've fully covered the mixed terms $xy,xz,yz$, so now we need to include two more: to keep things symmetric, let's say $x^2+y^2$ and $z^2$.
Except, here's the thing: the pure-square monomials $x^2,y^2,z^2$ in $(*)$ are not linearly independent! Why is this? well, because we're on the unit sphere, which means that these terms satisfy the identity
$$
x^2+y^2+z^2 = 1,
$$
and the constant term $1$ is already in our basis set. So, from the combinations $x^2+y^2$ and $z^2$ we can only form a single polynomial, and the correct choice turns out to be $x^2+y^2-2z^2$, to make the set not only linearly independent but also orthogonal (with respect to a straightforward inner product).
As for the rest of the spherical harmonics $-$ the ladder keeps climbing, but the steps are all basically the same as the ones I've outlined already.
Anyways, I hope this is sufficient to explain why the spherical harmonics are
a complete orthonormal basis for the space of the functions defined on the sphere.
This is just a fancy way of saying that, if you have a function $f(\mathbf r)$ that's defined for $|\mathbf r|=1$, then you can expand $f(\mathbf r)$ as a "Taylor series" of suitable polynomials in $x$, $y$ and $z$, with a slightly reduced set of polynomials to account for the restrictions on $|\mathbf r|$.