At each point $p$, of course, there's always an orthonormal basis for $T_pN$ diagonalizing $S_p$. You may likely have local smoothness issues whenever there are repeated eigenvalues. However, in dimension $n>2$, it's not good enough to say there are no umbilic points; you actually need to require distinct eigenvalues.