No. Aaron Hotchner (Thomas Gibson) does not die in the Season 5 finale—or at any point during Gibson's tenure on the series.
In the two-part finale, the BAU's nemesis George Foyet—aka The Reaper (C. Thomas Howell)—ambushes Hotch at his home. Foyet shoots Hotchner in the head at point-blank range. The screen cuts to black, leaving viewers in agonizing suspense over the summer hiatus.
Season 6 opens with the revelation that Hotch survived. The bullet grazed his skull, causing severe trauma but not a fatal wound. He spends the early episodes of Season 6 recovering—physically and psychologically—before returning to active duty. The experience deepens his character, adding layers of vulnerability and resolve that persist through his eventual departure in Season 12 (2016), prompted by Gibson's real-life exit from the series.
The cliffhanger was effective because:
Hotchner takes a bullet to the head, survives, recovers, and leads the BAU for six more seasons. The Reaper doesn't win—not then, not ever.