Destroy wallet payment source on source destroy

[tvdeyen]

Summary

A wallet payment source without an actual payment source does not make any sense.

Checklist

Check out our PR guidelines for more details.

The following are mandatory for all PRs:

• [x] I have written a thorough PR description.
• [x] I have kept my commits small and atomic.
• [x] I have used clear, explanatory commit messages.

The following are not always needed:

• 📖 I have updated the README to account for my changes.
• 📑 I have documented new code with YARD.
• 🛣️ I have opened a PR to update the guides.
• ✅ I have added automated tests to cover my changes.
• 📸 I have attached screenshots to demo visual changes.

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 89.14%. Comparing base (127d02c) to head (4ca261c). Report is 5 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #5836 +/- ## ======================================= Coverage 89.14% 89.14% ======================================= Files 744 744 Lines 17343 17343 ======================================= Hits 15460 15460 Misses 1883 1883 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.