Yes, the hard drive is very likely still functional. The "Red Ring of Death" (RRoD) indicates a motherboard failure (usually GPU/CPU solder fractures from overheating), not a hard drive failure.
Caveat: A severe power surge during the RRoD event could damage the drive, but this is rare. If the drive clicks or isn't detected, seek professional data recovery.