What would cause a user's activation link to fail?
They could already be active Users
Their activation link could have timed out


1) happens more often than I'd think, people try using it as a way of "getting to the site again"

2) Can be controlled in /config/general.php - https://craftcms.com/docs/config-settings#verificationCodeDuration