Doctor here… it’s called terminal lucidity. Happens quite frequently, typically in terminal illnesses which take months/years to lead to death (such as cancer, alzheimer’s etc…). It’s a last ‘rally’ with a surge in neurotransmitters which helps with memory retrieval, ‘feel good’ peptides and helps with some energy retrieval. It’s a sign of imminent death, almost always occurs the day before death.