Users in odd state of pending and needing password reset
Yeah... sounds like a registration workflow issue.  If they click on the activation link and it's past the time it's valid, the page does have a link where they can resend it, but that's only going to be helpful if they got the email in the first place.

I think for now you'll have to use the "Resend Activation Email" button in the CP.