In what sense is the connection enabling one to compare the vector field at two different points on the manifold [...], when the mapping is from the (Cartesian product of) the set of tangent vector fields to itself? I thought that the connection ∇ "connected" two neighbouring tangent spaces through the notion of parallel transport [...]
To see a connection only as a mapping $\nabla: \mathcal{X}(M)\times\mathcal{X}(M)\rightarrow\mathcal{X}(M)$ is too restrictive. Often a connection is also seen as a map $Y\mapsto\nabla Y\in\Gamma(TM\otimes TM^*)$, which highlights the derivative aspect. However, the important point is that $\nabla$ is $C^\infty(M)$-linear in the first argument which results in the fact that the value $\nabla_X Y|_p$ only depends on $X_p$ in the sense that
$$
X_p=Z_p \Rightarrow \nabla_X Y|_p = \nabla_Z Y|_p.
$$
Hence, for every $v\in TM_p$, $\nabla_vY$ is well-defined. This leads directly to the definition of parallel vector fields and parallel transport (as I think you already know).
Vice versa, given parallel transport maps $\Gamma(\gamma)^t_s: TM_{\gamma(s)}\rightarrow TM_{\gamma(t)}$, one can recover the connection via
$$
\nabla_X Y|p = \frac{d}{dt}\bigg|_{t=0}\Gamma(\gamma)_t^0Y_{\gamma(t)} \quad(\gamma \text{ is a integral curve of }X).
$$
This is exactly the generalisation of directional derivatives in the sense that we vary $Y$ in direction of $X_p$ in a parallel manner.
In Euclidean space this indeed reduces to the directional derivative: Using the identity chart every vector field can be written as $Y_p=(p,V(p))$ for $V:\mathbb R^n\rightarrow \mathbb R^n$ and the parallel transport is just given by
$$
\Gamma(\gamma)_s^t (\gamma(s),v)=(\gamma(t),v).
$$
Hence, we find in Euclidean space:
$$
\frac{d}{dt}\bigg|_{t=0}\Gamma(\gamma)_t^0Y_{\gamma(t)} = \frac{d}{dt}\bigg|_{t=0}(p,V(\gamma(t))) = (p,DV\cdot\gamma'(0)),
$$
which is exactly the directional derivative of $V$ in direction $v=\gamma'(0)$.
Back to the original question: I think it is hard to see how a connection "connects neighbouring tangent spaces" only from the axioms. You should keep in mind, however, that the contemporary formalism has passed many abstraction layers since the beginning and is reduced to its core, the axioms (for a survey see also Wikipedia). To get the whole picture, it is essential that one explores all possible interpretations and consequences of the definition, since often they led to the definition in the first place. In my opinion, the connection is defined as it is with the image in mind that it is an infinitesimal version of parallel transport. Starting from this point, properties as the Leibniz rule are a consequence. However, having such a differential operator $\nabla$ fulfilling linearity, Leibniz rule and so on, is fully equivalent to having parallel transport in the first place. In modern mathematics, these properties are thus taken as the defining properties/axioms of a connection, mainly because they are easier to handle and easier to generalise to arbitrary vector bundles.
Given this, what does the quantity $\nabla_{e_\mu}e_\nu=\Gamma^\lambda_{\mu\nu}e_\lambda$ represent? [...]
As you wrote, the connection coefficients / Christoffel symbols $\Gamma^\lambda_{\mu\nu}$ are the components of the connection in a local frame and are needed for explicit computations. I think on this level you can't get much meaning out these coefficients. However, they reappear in a nicer way if you restate everything in the Cartan formalism and study Cartan and/or principal connections. The Wikipedia article on connection forms tries to give an introduction to this approach.
Nahakara also gives an introduction to connections on principal bundles and the relation to gauge theory later on in his book. In my opinion, this chapter is a bit short and could be more detailed, especially to the end. But it is a good start.
Best Answer
In short, the answer to your question is yes.
However, perhaps going into a bit more generality would be useful. Let $M$ be a smooth manifold, $\nabla$ an affine connection on $M$, and $c:[0,1]\to M$ a smooth curve.
We may consider the following two things: the pullback bundle $c^*TM$ (which is a bundle over $[0,1]$), and the pullback connection $c^*\nabla$ (which is a connection on the pullback bundle). In your original question you consider the bundle $TM\vert_{c(t)}$, i.e. the restriction of the tangent bundle to the image of the curve. By construction of the pullback bundle, this is the same as $c^*TM$. We will shortly see that $c^*\nabla$ induces $D/dt$.
The pullback connection is characterized as follows. We know it is a map
$$ c^*\nabla:\Gamma(c^*TM)\times\mathcal{X}([0,1])\to\Gamma(c^*TM). $$
Suppose $V\in\mathcal{X}(M)$ is a vector field on $M$ and $X\in\mathcal{X}([0,1])$ is a vector field on $[0,1]$, then $c^*\nabla$ is uniquely determined as the connection on $c^*TM$ that satisfies
$$ (c^*\nabla)_X(c^*V)=c^*(\nabla_{dc(X)}V). $$
In particular, suppose we consider the map $D/dt$ but now defined as
$$ (c^*\nabla)_{\frac{d}{dt}}:\Gamma(c^*TM)\to\Gamma(c^*TM), $$
where $d/dt\in\mathcal{X}([0,1])$ is the standard global coordinate vector field.
Then, as in your question, let $V$ be a vector field along $c(t)$ (in particular, $V\in\Gamma(c^*TM)$) and further suppose $V$ is induced by a vector field $\tilde{V}\in\mathcal{X}(M)$ (in particular, $V=c^*\tilde{V}$). Then by definition of the pullback connection
$$ \dfrac{D}{dt}V=(c^*\nabla)_{\frac{d}{dt}}(c^*\tilde{V})=c^*(\nabla_{c'(t)}\tilde{V}), $$
where we note $c'(t)$ is shorthand notation for $dc(d/dt)$. Now, we note that the RHS $c^*(\nabla_{c'(t)}\tilde{V})$ can be identified as the restriction of $\nabla_{c'(t)}\tilde{V}$ to the image of the curve $c(t)$.