An object "at rest on the Earth's surface" is not following a geodesic. The object must be sitting on some surface (usually called the floor) to remain at rest. The floor exerts a force on the object causing it to have a non-zero proper acceleration.
[add]Rephrasing this slightly, which may be clearer, the force the floor exerts on the object causes it to follow a path that is not a geodesic. If the floor did not exert a force on the object, it'd fall through the floor towards the center of the Earthy.
The relative acceleration between an object "at rest" on the floor and an object following a free-fall geodesic is a property of the Earth, and is approximately 9.8 m/s^2, though it varies slightly with location. Another poster has given the details of the calculation of this value from a specific coordinate system, called the "Earth Centered Inertial Coordinate System", according to the mechanics of GR. The name "inertial coordinate system" may unfortunately be a bit misleading, as there is no such thing as an inertial frame in any curved space-time, of which the space-time near and around the Earth is an example. However, for historical reasons, that's what this coordinate system is called. See for instance
https://arxiv.org/abs/gr-qc/9508043, "Precis of General Relativity" for details on the ECI coordinate system and it's associated metric. (Note that the above link is to the abstract of the paper, clicking on PDF will give the PDF version, which resolves to
https://arxiv.org/pdf/gr-qc/9508043.pdf).
In Newtonian theory, gravity is regarded as a "real force" which acts on an object. GR uses a different model and different terminology - the object "at rest" is only at rest in some specific coordiantes (the ECI coordinates), which, however, are in common use. It's not following a geodesic, that's why the geodesic equation does not evaluate to zero. It's not following a geodesic because the floor is exerting a force on the object.