Charlie - who's survived by his wife Erika Kirk and their two children under age 3 - will be honored at a memorial service scheduled next Sunday at State Farm Stadium in Glendale, AZ