The problem is most likely with Colossus, not SONAR. Refer to the Colossus user manual for instructions on MIDI automation.
If all you want to do is automate volume specifically, then the easiest way to do that is to automate the audio track rather than the MIDI track. As noted above, this will be simpler if you use separate MIDI and audio tracks rather than a Simple Instrument Track.