There are many benefits to core aeration including lessening soil compaction, controlling thatch build up, increasing water and nutrient uptake, improving rooting, increasing heat and drought stress tolerance, etc.
Aeration can be performed at any time in the growing season as long as the soil is moist enough for tine penetration.