In General relativity, the metric tensor that satisfies Einstein's equations induces the Levi-Civita connection of that metric.
It is said that this connection is somehow "compatible" with the metric.
Technically Im told this means that straight lines (according to the connection) coincide with geodesics (according to the metric). However, this seems like an arbitrarily restrictive assumption from a mathematical point of view. Shouldn't it be possible for a single specific metric manifold with connection to have straight lines that are not necessarily geodesics? Why not?
So my main question is: what does this notion of "compatibility" of metric and connection really mean intuitively? Does it mean there cannot exist a metric manifold with connection whose metric and connection are incompatible? (I.e. is it a necessary condition?). Why is the intuitiv enotion of "compatibilty" captured formally by the "straight lines = geodesics" criterium?
We can use a pseudo-Riemannian metric $g$ to identify one-forms and vector fields, by raising and lowering indexes. For example, if $\omega$, the vector field $\omega^\sharp$ is the only one satisfying $\omega(Y) = g(\omega^\sharp,Y)$ for all $Y$, and if $X$ is a vector field, we have a one-form $X_\flat$ defined by $X_\flat(Y) = g(X,Y)$, for all $Y$. The non-degeneracy of the metric ensures that $\sharp$ and $\flat$ are isomorphisms.
Every connection induces total covariant derivatives, and so it makes sense to look at $\nabla_V\omega$ and $\nabla_VX$, for a given vector field $V$.
The condition that the connection is compatible with the metric or, in other words, that the metric is a parallel tensor ($\nabla g = 0$) tell us that $$\left(\nabla_V\omega\right)^\sharp = \nabla_V \omega^\sharp \quad\mbox{and}\quad \left(\nabla_VX\right)_\flat = \nabla_VX_\flat. $$Meaning that not only $\nabla$ commutes with contractions, $\nabla$ will also commute with metric contractions.
A priori this doesn't have any relation with geodesics, since you can define what is a geodesic with respect to an arbitrary connection (not necessarily the Levi-Civita connection), and you don't need a metric to define a connection. Similarly, you can define a metric in a manifold which has no connection. The motivation of the Levi-Civita connection is to have a good enough connection that relates these two concepts.