When a hard drive starts spinning up and down at power on, there are 2x obvious reason.

Either the heads are stuck in the parked position and repeated attempts free them.

Other possibility is that the PSU is not giving enough power, probably due to failing capacitors.

Given the age, both the logic board and the PSU need to be recapped.

I don't think that a new pram battery will be enough to solve your problem.