This is a problem that's been around in one form or another for quite a while. Basically the AirPort card doesn't correctly detect its own power state after the machine wakes up. As sknapp351 noted, it doesn't correctly try to reconnect under Tiger either. Disabling your security is a VERY BAD IDEA. It's not that difficult to get the card to do the right thing-though it would be nice if Apple fixed the firmware so it did so by iteself.
Instead of telling the card to reconnect, just tell it to disconnect. When it does so, it will detect your wireless network normally and probably connect by itself. No entries to be made, no fuss.
The real issue here is how the card keeps track of what's going on when it goes to sleep with the computer, and how it attempts to recover its security state. Since WPA-Personal uses Temporal keys, they expire rather quickly, a good thing for security, but when the computer's been asleep for a while, the card no longer has a valid key. Since it doesn't remember going to sleep (a major blunder on the part of Apple), it thinks the normal network is gone and it tries to connect via WEP. By telling it not to, you put the card back into a "search for network" mode, wherein it will detect the existing network-correctly this time, having dumped its old keys-and usually it will automatically connect.