Fibrations in complete intersections of quadrics, Clifford algebras, derived categories, and rationality problems