Page 166 of this book says that
any geometry, no matter how curved, is locally flat, at each spatial point we can always construct an infinitesimal patch of a Cartesian coordinate system.
By question is what can be (or how to think about) the local Cartesian coordinates on the surface of an unit sphere? Since it is a Cartesian coordinate the metric tensor must be $\delta_{ij}$. If I use $(x,y,z)$ system, the metric tensor does bot become $\delta_{ij}$ because of the constraint $x^2+y^2+z^2=1$. In spherical polar Coordinates too, the metric is not $\delta_{ij}$.