Will I need to enter my ATG email password every time I log in with a social account?

No - When signing in with your Google or Apple account, you only need to enter your ATG email password the first time you sign in to link both the email and social accounts together.