As Wikipedia says, a great circle is a circle formed by the intersection of a sphere and a plane that passes through the center of the sphere.
The great circles parametrized by $\theta =\tau$ and $\phi =\text{const}$ are not all the great circles. They are only the `vertical' great circles, that is, the great circles formed by intersection with a plane that contains the $z$-axis. (You will find that the general solution to the Euler-Lagrange equations of your Lagrangian is $\theta (t)=at+b$, $\phi =\text{const}$, for some constants $a$ and $b$. We an then just define $\tau :=at+b$, so that $\theta =\tau$. This is nothing more than a simple reparametrization.) If you need help visualizing these curves, I suggest you work on your understanding of spherical coordinates.
Now I will sketch how one actually shows that these great circles are the equations of motion. You should find that the Euler-Lagrange equations are
\begin{align}
\ddot{\theta} & =\dot{\phi}^2\sin (\theta )\cos (\theta ) \\
\frac{\mathrm{d}}{\mathrm{d}\, t}\left( \sin (\theta )^2\dot{\phi}\right) & =0.
\end{align}
The latter equation implies that $\sin (\theta )^2\dot{\phi}=\text{const}$. As the particle will at some point be located at one of the poles, we find that this constant is $0$ (by plugging in $\theta =0,\pi$). Thus, $\dot{\phi}=0$. The first equation then becomes $\ddot{\theta}=0$.