Yes, any SSO disables other login sources. The first S in SSO stands for Single. You’re delegating all sign-on to another system.
You could experiment with logging in your Patreon users via WordPress.
Failing that, if you want Discourse to allow multiple login methods you may need to revisit your WordPress SSO integration.