In a post-9/11 New York, Mike Piazza provided some healing in the form of a home run on an emotional night at Shea Stadium