Yes, the Hooker aerator still works pretty well in hard clay soil. The original aerator was developed in Georgia.
Sure, if it's really really dry you may not get full depth but it does surprisingly well since it is has the "hooking" tines and isn't soley dependent on down pressure. The Hooker, in general, does better in somewhat dry conditions. No need to have a watered, saturated lawn before you aerate.
I won't make the claim that you can aerate concrete.