Take any static spacetime. The metric in such a spacetime may be written in static coordinates ##t## and ##x^i## as
$$
ds^2 = f(x)\, dt^2 - d\Sigma^2
= f(x)\, dt^2 - g_{ij} dx^i dx^j
$$
where ##d\Sigma^2## is the (Riemannian) metric on the spatial slices defining simultaneous static time.
By the time translation symmetry, it follows that
$$
E = g(\partial_t, \dot \gamma) = f(x)\dot t
$$
is constant for any spacetime geodesic ##\gamma##. The spatial parts of the spacetime geodesic equations take the form (assuming I did the math right)
$$
\bar\nabla_{\dot x} \dot x^j = \frac{E^2}2 g^{jk}\partial_k(1/f)
$$
with ##\bar\nabla## representing the affine connection on the spatial slices. For the worldline to correspond to a geodesic when projected on the spatial slices, this should at the very least satisfy the non-affinely parametrised geodesic equations on the spatial slice. This would require the RHS to be proportional to ##\dot x^j##, which is not the case.