The Cardinals hosted a John Goodman Night at Busch Stadium to celebrate the actor and St. Louis native