Ok, let us (well...me...) just concentrate on the Schwarzschild metric. The first thing I think of after hearing this metric is "spherical symmetry". The Schwarzschild metric is stationary if there is a coordinate system in which the metric is time-independent, right? And is it correct that the vector field, X, is Killing because the metric is stationary? I mean, if I have a stationary metric, then there is a coordinate system in which the metric is time-independnt
[tex]\frac{\partial g_{ab}}{\partial x^0} = 0[/tex]
then define a vector field [itex]X^a = \delta^a_0[/itex] in the special coordinate system, then
[tex]\mathcal{L}_X g_{ab} = X^c g_{ab,\,c} + X^c{}_{,\,b}g_{ac} + X^c{}_{,\,a}g_{bc} = \delta^c_0 g_{ab,\,c} = g_{ab,\,0} = 0[/tex]
and since [itex]\mathcal{L}_Xg_{ab}[/itex] is a tensor, if it vanishes in this special coordinate system, it must vanish in all coordinate systems. Hence X is a Killing vector field.
Conversely, if I have a timelike Killing vector field X, then there exists a coordinate system which is adapted to the Killing vector field and then
[tex]\mathcal{L}_X g_{ab} = g_{ab,\,0}[/tex]
and therefore the metric is stationary. So
A spacetime is stationary if and only if it admits a timelike Killing vector field.
Then
A spacetime is spherically symmetric if and only if it admits exactly 3 linearly independent spacelike Killing vector fields whose orbits are closed and which satisfy
[tex][X^1,X^2] = X^3,\quad[X^2,X^3] = X^1,\quad[X^3,X^1] = X^2[/tex]
Is this what you mean when you said
to be ultra-formal, one can describe this body at rest as following the orbit of a time-like Killing vector associated with the stationary metric - all stationary metrics have by definition time-like Killing vectors).
Is a line of longitude on the Earth an example of one of these orbits?
Then solving Einstein's field equations in a vacuum, assuming spherical symmetry, you get the Schwarzschild solution (which is a metric) which is stationary and the coordinate system used is adaptable to a Killing vector field [itex]X^a = \delta^a_0[/itex] since
[tex]X_a = g_{ab}X^b = g_{ab}\delta^b_0 = g_{0a} = g_{00}\delta^0_a = (1-\frac{2m}{r},0,0,0)[/tex]
From this, is it possible for me to say that the Killing vector field X is
hypersurface-orthogonal?
I mean, if I now have a hypersurface-orthogonal Killing vector field then surely the vorticity tensor of the timelike congruence vanishes. But basically that means that a spherically symmetric spacetime with the Schwarzschild metric admits an irrotational timelike Killing vector field.
So if I have a spherically symmetric spacetime (i.e. one with a singular massive object at the origin) in which I can assume that it is asymptotically flat then the isometry group contains a subgroup isomorphic to the rotation group [itex]\mathcal{SO}(3)[/itex], and the orbits of this group are 2-dimensional spheres.
The isometries are generated by the Killing vector field which implies, among other things, that the Schwarzschild metric is invariant under rotations.