Designing Data Intensive Applications (DDIA) is the best book I’ve come across when it comes to serious system design.
It might help, but it's not necessary from my experience. I've gotten into a FAANG company (an SRE position) without 'studying the test', just studying practically applicable materials. And I know plenty of other people who did the same.
I suspect the next thing to counter too much studying to the test will be to add an additional type of interview round (leetcode/system design/new thing) to the process, further extending it.
(When you have to explain it, you realize that a lot of common terminology in the "tech community" kind of sucks!)
DDIA is to system design, as a computer science textbook is to the algo interview.