I don't think the automation cares about the sample rate.
Voxengo has a free utility called R8brain.
If you used per-project audio folders where all the project audio is in one folder, you should be able to apply R8brain on all audio files at once using R8brain's batch mode.
Change the project's default sample rate to the new sample rate (just to be safe).
With the project closed, convert the audio files to the new sample rate with R8Brain.
Once the files are sample-rate-converted, Sonar should open the project with the files at the their new sample rate (without making a new project).
Theoretically, R8Brain will convert ALL the audio files, including clips. All the automation should remain untouched by the conversion.
I did this years ago and it worked but maybe someone could chime in here and confirm this.
And for sure, don't do this on the orig project files. Make a copy of the entire project including audio files and work on that.
If you did not use per-project audio on the old project, enable per-project audio and 'save as' a new project including audio so all the project's audio is in one folder.