No, the WHMCS Membership plugin doesn't automatically create users in WordPress. The plugin checks if the user logged in to WordPress also exists in WHMCS (based on the email address). If so, it will check what products the user has and based on that will authorise access to protected WordPress pages.