Mike Piazza shares the emotions of his legendary home run against the Braves in the first game back in New York after the 9/11 attacks