Repeated nuisance alarms have the same effect on all humans, not just on pilots - it trains them to ignore the alarms. Eventually this will lead to non-nuisance alarms being ignored and lives being lost.
This kind of counter-intuitive/smarter-than-the-obvious pontification is a HN smell to me. Most of the time the obvious solution is correct. Driver attention management is one of the biggest (maybe the biggest) contributors to accident rate, and IMHO probably deserves some assistive technology attention. If the reverse is true, it needs actual evidence and not an attempt to reason from aviation evidence (a regime where inattention is NOT a major problem!).