Probably not to replace excercise, although who can say with gene editing.

Reducing, stopping, counteracting mental decline is a holy grail in medicine. I think there has been some progress here.

And on the general mental acuity note there are things like modafinil.

The best things known work are do what you need to do to get good sleep, and find some way to exercise routinely.