For 100,000 sq ft, you could do with having a larger aerator but I'll offer my 2c anyway.
I have about 45,000 sq ft of rock/clay soil. I bought a 48" agrifab tow along aerator a couple of years ago to deal with heavy compaction.
It has made a huge difference to my lawn. I use my aerator twice a year, once in spring and again in autumn. As was said above,
The soil has to be damp, otherwise you are just wasting your time. Usually about 2 days after a good heavy rainfall is perfect. Too dry, you dont get penetration, too wet and the whole place gets destroyed with mud cakes. I usually put about 100-150lb of sandbag weights on my aerator to get best core depth and usually make about 4 passes in various directions. The lawn WILL look horrible afterwards but that only lasts a couple of weeks. You could sweep up the cores but I dont think its needed. I add sand to my lawn after coring to try to loosen up the structure of my soil and it is making a difference. I expect this is a long term project and will just be an ongoing ammendment for my soil.
As for hitting a rock with the aerator, You do feel it. I haven't bent a tine yet but I have hit plenty of rocks, My aerator simply rides up over the rock and back down again. I havent had a problem with the tines getting blocked with small stones?
For thatch I have a tow along 4ft rake dethatcher. I used to use it regularly before I started core aerating but have not used it in years. Perhaps the aerating is keeping control of the thatch, I never gave it much thought until now...
For my 50,000 sq ft area, with 4 passes, using a 4ft core aerator, it takes about 4-5 hours in the seat...