There was a declaration by Cakewalk that beginning with one of the X2 or X3 versions of Sonar, it would not run on anything less than Windows 7 with Service Pack 1.
Also - I am not sure if 32-bit DXi plugins will necessarily run on a 64-bit Windows, but that is really speculation on my part, as I don't use any 32-bit DXi plugins any longer (to the best of my awareness, anyways). Cakewalk still has a small number of DX plugins, but I believe there was some internal rework by them to get them to where they would run in 64-bit OS environments.
That all being said, you CAN install both a 32-bit Sonar and a 64-bit Sonar on a given 64-bit capable computer running 64-bit Windows 7 with SP 1 or higher.
Windows 8.1 or 10 are also options, but in any case, you will want to do some checking for any needed drivers for things like hardware (midi controllers, audio interface) to make SURE there are indeed production released drivers for whatever version of Windows you will be moving to from the current XP.
Once you get a nice shiny new computer together, and if needed get rid of a bunch of the bloatware free trial crap and software not desired, you CAN download a free Sonar demo and it will let you test out the user interface and the Sonar audio engine. There are some restrictions and limitations, but you could still get a pretty good idea of whether or not it is a good idea to move to one of the current versions.
You could probably also install whatever version of Sonar that you are/were running on the XP computer, along with any new version of Sonar you decide to move to. That way, you would/should be able to access your older projects in THAT version, if for whatever reason you can't get them to open in say Platinum.
As always, these forums are chocked full of friendly and helpful folks to work with you on getting things squared away.
Bob Bone