We've been at the Templo Mayor site a few times before, but always when it was closed. But we finally made it there during the day. My pyramid-loving son thought it was great.
Also, if you go there, make sure to check out the Metro stop next to the Cathedral. That's where we saw the model of the site.