The actor's wife Kimberly and their six children made a surprise appearance on stage at the Richard Rogers Theatre in New York City , bringing the show's cast to tears