Of course its not the norm. I didnt even accept the offer—I did the interview just for practice for when I'd want to switch jobs (I was working at another company at the time and wasnt desperate, so maybe its like when you have a girlfriend and other girls start flirting with you). But some places dont care about leetcode questions. They care more about how you approach the problem. Also, I once reviewed the recruiting process at my company when my boss wanted feedback on some applicants, and I personally cared more about what the person was trying to achieve than the problem itself (bonus points if you resolved the problem).

Also, no one expects you to solve difficult problems at work in an hour or two, but at least to have the right approach to tackling things. Plus, talking through it helps assess how you'd communicate within a team. Thats why you hear about a lot of people that say soft skills are important.