On the classification of non-big Ulrich vector bundles on surfaces and threefolds