wallet: Disable creating and loading legacy wallets

To prepare for the deletion of legacy wallet code, disable creating or loading new legacy wallets.

Tests for the legacy wallet specifically are deleted.

Depends on #31248 and #31241

Split from https://github.com/bitcoin/bitcoin/pull/28710