Clarify names around the swh.core.db.pytest_plugin tests

This renames the test file to test_pytest_plugin which is clearer since it
relates to the actual module being tested.

This also moves the tests into its own dedicated arborescence because that's a
different module now.