On the geodetic number and related metric sets in Cartesian product graphs