Yes that is correct. You will actually get notifications from both programs. If you decide you like handcent then you will need to go into the settings inside the stock messaging app and turn off notifications.
As wilderside said - you can uninstall the Handcent app if you don't like it...you can uninstall thru the Market or thru the phone settings - applications - manage applications - find the app, open, click uninstall...