TST: Added match argument for most uses of tm.assert_produces_warning
xref #58290
Places where I skipped match argument:
`computation/test_eval.py` and `frame/test_query_eval.py` as I couldn't get the tests to trigger the warning
`plotting/test_datetimelike.py` same reason as above.

The tests for internal things in `util` folder: 
`test_assert_produces_warning.py`, `test_deprecate_kwarg.py`, `test_deprecate_nonkeyword_arguments.py`, `test_deprecate.py`



other places I skipped because it would complicate the logic (I.E. `api/test_api.py`'s `test_depr` method.)

Thanks @Aloqeely (agreed that it would be nice to enforce `match` for `assert_produces_warning`)