Do users need to login to MemberPress separately?

Nope. MemberPress uses the standard wp_users table to store your users' information. That means that when a user logs into your site, they're logging into the whole site.

Once a user is logged in, we use MemberPress rules to verify that user's level of access to your protected content.