Consider a car driving around in a circle lying in the plane and suppose we were interested in determining its acceleration as measured by an observer stationary on the "ground" or whatever. Introducing cylindrical coordinates is a traditional route for this end.
Thus we introduce cylindrical coordinates in order to describe the riders planar motion. We will have a unit vector $\textbf{e}_r$ along the radius and another unit vector $\textbf{e}_\theta$ perpendicular to $\textbf{e}_r$. These unit vectors "follow" along with the car in the sense that they are always rotating.
So in this system, and as well as for the stationary system of the observer, the acceleration of the car is given by:
$$ \boldsymbol{a} = (\ddot{r} - r \dot{\theta}^2) \textbf{e}_r + (r \ddot{\theta} + 2\dot{r}\dot{\theta})\textbf{e}_\theta $$
The term $2 \dot{r} \dot{\theta} \textbf{e}_\theta $ is the Coriolis acceleration.
Now, I wonder why it does in fact appear in the expression. Because from my understanding, a rotating system is not inertial. How can then measurements of the car's acceleration made in that rotating, non-inertial system perfectly account for and coincide with the car's acceleration as observed in the stationary observer's system?
What perplexes is me is that we are using a rotating and non-inertial system, i.e. the cylindrical coordinate system, and we make calculations in it that happen to satisfactorily describe the acceleration as the stationary observer's non-rotating and inertial system would measure them. What!?
Now clearly since the Coriolis acceleration is in fact apparent in the expression for acceleration tells us that the rotating system is inertial, so the observations made in that rotating system is the same as the stationary one. How? I am obviously missing something here. What?