Yes, non-notability decreases SNR because it ends up crowding articles into disambiguation pages which makes it more difficult to traverse related articles on the site. It is generally preferable not to stumble across non-notable articles when browsing Wikipedia.

It is also more work for editors to 'maintain' non-notable articles over time. Having notability standards significantly reduces this burdain.