Look through the plugin’s settings for any login redirects it creates. It seems that it’s redirecting users to their profile page before the WP Discourse plugin can redirect users back to Discourse. If you find the solution, please post it here. If you don’t find the solution, let us know. I can try installing MemberPress on my local site.
Yes, the Health Check plugin is great for debugging this kind of thing.