You have to match the level of prep to the jobs you're pursuing. You don't need to grind LeetCode to have a SWE career. Most people never do that.
However if you're trying to get the more competitive jobs then some prep is necessary, as you already discovered with your Google interview.
The reason so many people do interview prep is that the ROI can be extremely high. Spending 100 hours grinding LeetCode sounds like hell to most people. Spending 100 hours doing practice problems to get a $100K raise for a job where you stay for 3 years suddenly becomes a $3000/hour career booster. That high paying job opens doors for more high paying jobs in the future, so the real number is even higher.
That's why people do it. You don't have to do it and it's not guaranteed to get you the high paying job by itself, but for people in the position to take advantage of it, the ROI is huge.
(This of course works for all kinds of things, not just interviewing: Quotes for house work, car purchase / sell offers, etc. Simply get more than one, and poof you get better deals).
But my job is very demanding and I have 4 hours after work to spend with my wife and kids before I have to start all over again. I'm just not in a season where interview prep (which may as well be a university 16-week course) is reasonable.
Since the day-to-day job rarely requires it, and I've gotten jobs without it, there's little incentive to change unless I want to.
Nothing wrong with that - nice position to be in actually.
I have a list of past projects I'm comfortable talking about. I can go to great lengths talking about any of them in detail if prompted. I'm also comfortable talking about technical topics including those I'm not intimately familiar with - that's part of my job after all. But most importantly, I'm confident enough that I can say "I don't know what that is, can you elaborate?" and "I'd need to look into that and get back to you".
I've you're going to leetcode me, I'm going to underperform. I've never had to do leetcode for a job. I also don't typically apply to the kind of companies that think leetcode is a good filter. Why should I waste their time and mine to apply to a job at a company I'm probably going to hate working for?