Go and vote in this poll http://talk.maemo.org/showthread.php?t=36702 and let Nokia know that their assumptions about always being connected via cellular are wrong.

Another option is to enable the "silent" profile at night (like all nokia phones, the alarms still make noise even when silent)