It seems like you may have read too much into his review.
Sometimes people do just want to learn how to drive a car, not how to assemble one from scratch or whatever. If you're expecting the former and you get the latter, it's understandable why you'd be frustrated. There's nothing wrong with that and Norvig doesn't say there is.
I do not understand your criticism of the 1 in 50 quote from Knuth. He's not saying only 1 in 50 are suited for programmers (and therefore everyone who isn't is wrong).
He's saying the set of people who think like that is larger than 1 in 50, as evidenced by 25 5-star reviews. The implication is that if you think like Knuth, you'll enjoy SICP, which doesn't seem that far from the truth, considering how esoteric Knuth and SICP may be for some people.