It can help to fall back on an extrinsic point of view to get some intuition.
Let $S$ be a Riemannian manifold of dimension 2, smoothly embedded in $\mathbb R^n$. We can associate with each point in $S$ a vector in $\mathbb R^n$. Of course, $\mathbb R^n$ has an inner product, but we naturally do not expect the inner product of two points in $S$ to tell us anything about the geometry of $S$.
When you introduce a pair of coordinates to parameterize $S$, you can talk about the tangent space. Let $s$ be the position of some point in $S$, then the vectors in the tangent space taken on the form
$$e_x = \frac{\partial s}{\partial x}, \quad e_y = \frac{\partial s}{\partial y}$$
Again, $s$ is a vector in $\mathbb R^n$, so these expressions have a sensible, concrete meaning.
The metric, then, merely tells us about the vectors in the tangent space and how they are related to each other. You can write it as
$$ds^2 = (e_x \cdot e_x) dx^2 + (e_y \cdot e_y) dy^2 + 2 (e_x \cdot e_y) dx \, dy$$
So the metric tells us whether the tangent space vectors are orthogonal to one another, and about their lengths. This is the basic extrinsic viewpoint; intrinsically, one has to work a little harder, but hopefully this is enough to gain some intuition.