I do not believe they're normal for the top schools. Absolutely not for MIT, and as one of the top 4 (with no real second places) CS schools I'd hope CMU's CS department is the same.
But we do need more information. E.g. if you think you want to major in EECS at MIT you'll likely take your first course before you declare your major at the end of your freshman year, and if it's really not for you you have a good chance to realize it. Prior to the new post-dot com crash panic curriculum this has been complicated by the department's opinion that you can't separate EE and CS and what that entails, but still, no one will think twice of your transferring in your sophomore year.
But at CMU you apply to the department for that major, for one of 135 seats, so we'd be astounded if there wasn't this sort of attrition, and to judge this experiment we'd need to know if it changed significantly. Still, my general point remains, the author is totally failing to realize, let alone think about the attrition rate.