The 51-year-old America's Got Talent judge transformed the grand opening of Crazy Pizza NYC in Manhattan's SoHo neighborhood on Tuesday night into a family affair