This isn't true in computer science at Harvard - I speak from experience, having gone through the tenure process there myself. Being denied tenure in CS at Harvard is about as bad as being denied tenure anywhere else; people don't usually end up in very good jobs afterwards. In my 8 years at Harvard, we awarded tenure to 5 junior faculty, and denied tenure to two.