Non-big Ulrich bundles: the classification on quadrics and the case of small numerical dimension