There is no automatic translation in Brave anymore, it was disabled by Brave team months ago, and who knows when they will re-enable it.
You can start Brave with --enable-features=BraveEnableAutoTranslate and I think it should still work.
It’s the same case as when I talked about it months ago in January.