Currently, Brave does not automatically open specific websites in specific containers (often called auto-container rules). Brave's native container feature requires you to manually right-click an existing tab and select "Open in container". The reason the site is not logging in is that each container creates an isolated session. Your login cookies, which authenticate you on that website, are sitting in your default/main browsing session, not inside the new container tab.