Refactor join form to use transactions instead of try/except

[Andrew-Dickinson]

Exception handling on join form submission should use Django's feature for this: https://docs.djangoproject.com/en/5.0/topics/db/transactions/

Whoops

Also add tests for those intermediate failure cases if they don't already exist