It's perfectly possible to have a successful SWE career without touching Leetcode-style questions. It's just that most of those jobs don't pay well.
However the places that actually do read my open source work, do contact my references, and where the interview has had no tech assignments of any kind other than a simple discussion about a variety of topics, perhaps just going over some of my OSS projects, the higher the salary has been.
This is in Northern Europe though, your mileage may vary.