It seems like all the resources I find on representation theory are done for representations over the complex numbers. For those, I know how to classify all representations of $SO(3)$: they are direct sums of irreducible ones, and the irreducible representations are isomorphic to the action of $SO(3)$ on the spherical harmonics. But applying these results to real representations seems to go wrong, since $\mathbb{C}$ being algebraically closed pops up in a bunch of places.
I think the action on the real spherical harmonics continues to be irreducible, but does that classify all of the irreducible real representations? And does the classic result that representations of compact groups are direct sums of irreducible ones hold for real representations? Any resources on representation theory that discusses real representations as well as complex ones would be helpful too!
Partial answer to the second part of your question. Yes, that is enough. The spherical harmonics form a basis for the $2 \ell + 1$ dimensional representations of SO(3). Here is a nice reference. The author calculates the action of rotation about the z axis applied to the $Y_{l,m}$ and from this the character table for $SO(3)$.