Explicitly defining material property output to CSV object when expected by tester

[shikhar413]

Bug Description

Doing a clean up of the materials output system in MOOSE (idaholab/moose#29820), and a public app test in Blackbear is failing because of certain tests where material output to a csv output object is expected, but not explicitly set in the input file.

Steps to Reproduce

See https://civet.inl.gov/job/2765071/

Impact

Fix is needed in blackbear for material property cleanup and ensure that MOOSE PR passes all tests in order to merge