Does SET NOCOUNT ON eliminate @@ROWCOUNT values after table inserts?

Nope, SET NOCOUNT doesn't interfere with @@ROWCOUNT.

SET NOCOUNT is used to control message returned SQL server to client , it is not just for inserts alone, even for other DML statements as well.