Query total memory in failure_callback_resource_adaptor tests

[harrism]

Description

Fixes #1733 by querying total device memory and using twice as much in tests that are expected to fail allocation.

Checklist

• [x] I am familiar with the Contributing Guidelines.
• [x] New or existing tests cover these changes.
• [x] The documentation is up to date with these changes.

[harrism]

/merge