Seems reasonable to both heat/cool with "earthtubes", tied in to the greenhouse. Might take an HVAC guy, or the appropriate set of HVAC calcs, to figure out what benefit you'd get in temps.
I would further investigate the "earthtubing" pages at a site like "The Natural Home":
https://www.thenaturalhome.com/earthtube/
... lots of details about passive geothermal tube systems.
I can't imagine trying to use them for water collection, due to mold potential; if water is there, mold would probably follow. I'd keep the tubes nice and dry, and periodically cleaned out; the above site had a nifty solution to cleaning round earthtubes (nylon string, installed with pipes).
Depending on your humidity levels during night/day cycles (check with home weather system), I'd try for some way to gather moisture out of that ... above-ground, visible, easy access for maintenance. Might also be possible to rake in the frost, when it heats up & evaporates during day ... we always get a "morning drip" cycle after a freezing night.