Go to menu>settings>applications>messaging and clear the default. I'm using handcent on a rooted N1 and all I did was what I first suggested and I only get the handcent notifiction. Try clearing the messaging app as the default app, the next time you get a text a block should pop up asking which app should be default, check handcent and that should fix it.