I am closely following Lee's book on Riemannian Manifolds.
Let $(M, g)$ and $(\tilde{M}, \tilde{g})$ be a Riemannian manifolds such that $\iota: M \rightarrow \tilde{M}$ is an immersion and $g$ is the pullback of $\tilde{g}$ under $\iota$. Let $\tilde{\nabla}$ be a Riemannian connection on $\tilde{M}$ and $X, Y$ two arbitrary vector fields on $M$. Extend $X, Y$ arbitrarily to $\tilde{M}$so that the covariant derivative $\tilde{\nabla}_XY$ is well defined, which we can decompose as $$\tilde{\nabla}_XY = (\tilde{\nabla}_XY)^T + (\tilde{\nabla}_XY)^\perp$$ where $(\tilde{\nabla}_XY)^T$ is the projection of $\tilde{\nabla}_XY$ onto the tangent bundle $TM$ and $(\tilde{\nabla}_XY)^\perp$ is the image of the projection of $\tilde{\nabla}_XY$ onto the normal bundle $NM$. We then define the second fundamental form as $$\mathrm{I\!I}(X,Y) := (\tilde{\nabla}_XY)^\perp.$$
It can be shown that if $\nabla$ is the Riemannian connection on $M$ then $(\tilde{\nabla}_XY)^T$ is nothing but $\nabla_XY$, and so $$\tilde{\nabla}_XY = \nabla_XY + \mathrm{I\!I}(X,Y).$$
I understand the above pretty well, the second fundamental form tells you how much the two covariant derivatives differ. Where I begin to get lost is what happens after this. Everything is still clear algebraically, but less so geometrically and thinking in terms of curvature.
Lee proves two nice equations relating the second fundamental form and curvature:
The Weingarten Equation: $$\langle \tilde{\nabla}_XN, Y\rangle = -\langle N, \mathrm{I\!I}(X,Y)\rangle$$ and the Gauss Equation: $$\tilde{RM}(X,Y,Z,W) = RM(X,Y,Z,W) - \langle \mathrm{I\!I}(X, W), \mathrm{I\!I}(Y,Z) \rangle + \langle \mathrm{I\!I}(X, Z), \mathrm{I\!I}(Y,W) \rangle.$$
Lee also says:
For any vector $V \in T_pM$, $\mathrm{I\!I}(V, V)$ is the $\tilde{g}$-acceleration at $p$ of the $g$-geodesic $\gamma_V$. If $V$ is a unit vector, $|\mathrm{I\!I}(V, V)|$ is the $\tilde{g}$-curvature of $\gamma_V$ at $p$.
and
In the special case in which $\tilde{M}$ is $\mathbb{R}^m$ with the Euclidean metric, we can make this geometric interpretation even more concrete: $\mathrm{I\!I}(V, V)$ is the ordinary Euclidean acceleration of the geodesic in $M$ with initial velocity $V$.
I read in some other sources that the motivation for the second fundamental form comes from looking at a hypersurface in Euclidean space where there is a well defined normal vector and this is what requires us to consider an ambient manifold $\tilde{M}$ in the construction. But other than this I am lost on what the normal component of the covariant derivative has to do with curvature. I think this is also why I don't fully appreciate the two quotes passages above. Furthermore, I don't think I have a good intuition for "intrinsic" vs "extrinsic" curvature of a curve in $M$.
How can I see all this geometrically?