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
\frac{\partial g_{ab}}{\partial x^0} = 0
then define a vector field X^a = \delta^a_0 in the special coordinate system, then
\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
and since \mathcal{L}_Xg_{ab} 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
\mathcal{L}_X g_{ab} = g_{ab,\,0}
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
[X^1,X^2] = X^3,\quad[X^2,X^3] = X^1,\quad[X^3,X^1] = X^2
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 defintion 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 X^a = \delta^a_0 since
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)
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 \mathcal{SO}(3), 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.