Well, I think that it’s this:
And quite frankly, I don’t know what to do to keep people from thinking that this is a welcome message sent to all new users rather than the activation email that it is.
Maybe if
Welcome to %{site_name}!
was instead
Thanks for joining %{site_name}! You're almost there.
Maybe the word “welcome” is what is confusing? Now that I’m looking at this more closely, I really don’t know why people get this misunderstanding. @Paul_King1, can you help explain why you expected this to be a message that went to all users and not just those who needed to validate their email address?