How do I change the default SMS application on my HTC Hero?
One word. Root. I would suggest rooting as a solution to your problem. Here is documentation for how to root your CDMA Hero:
http://forum.xda-developers.com/showthread.php?t=581577