I thought it was a bit simplistic and narrow - no acknowledgement of the vast time span in which most ancient sites were built and used, possible changes in use over time etc, no comparison with sites elsewhere (could have included the recent woody discoveries at Stanton Drew, for example).
But I reckon Time Team is a great starting point for people to get interested. And I was chuffed that I could see my mate Tony's house in shot for much of the time, and The Stonehenge Inn where I used to drink underage in the early 80's. =;o)