His body will be raised, yes, but his spirit is with the Lord fren. See Philippians 1:23, wherein the Apostle Paul seeks to be with the Lord, and Luke 23:46, in which Jesus commits his spirit to his Heavenly Father... both these passages indicate that the death of the physical body does not mean the spirit remains in a sort of limbo - on the contrary, the spirits of the people of God go to be in heaven until we are given a new body at the second coming of Jesus Christ. The timing and aspect of this is laid out in detail in 1 Corinthians 15:35-57.

Now, regarding former Fire Chief Corey, the events surrounding his death are, of course, heartbreaking and enraging and rightfully so, but for those of us in the Christian faith (as he was and his family are), I praise the Lord that he's in a much better place than we are now.