Play notification alert sound when a message is still open
Have you tried using an alternative SMS app?  Handcent is very popular.  It has always notified me of a new SMS even with the message still open.

Edit: If you don't want to switch SMS apps, you can also use SMS Popup.