the only thing you may want to think about is not so much the bit depth, but the sample rate. the nomenclature works like this BTW: 24(bit)/ 96(khz). If your soundcard is only capable of doing 24 bit, that's all you are getting. 32 bit values beyond the 24 are not filled (or I think more accurately, filled with 0 values). Now, on to the real deal. If you plan on distributing your stuff (even just burning disks on your computer) you have to adhere to the format that you are using 24/96 is DVD, 16/44.1 is CD. (there are a couple of other configurations, but they are less common)
The sampling rate , if not handled correctly (and I don't think Sonar is capable of converting it)
will yield in errors if you try to burn a CD at 24/ 96khz. You can put 24/96khz on a DVD, but you'll have to listen to it on a DVD player.
Now here's the kicker. You can record at any bit depth you want (24/32/16, whatever) and dither it to 16 bit for CD distribution. It's just the sampling rate that is the sticker here. I think you will find a lot, if not almost all folks around here use 24/44.1 just to avoid the sampling rate conversion.
I know this is an oversimplistic view of how "it works" but I hope this gets you pointed in the right direction.