Use `testthat::with_mock()` instead of mockery

[gaborcsardi]

[jonthegeek]

I tried to do this for TDD 2025, but decided to work on other things. Some existing tests had errors, and others were taking forever to run, so I didn't want to try to update the tests to use local_mocked_bindings() without being sure that everything passed first.