[CI][Java][R] Improve notifications on failures for nightly R and Java jobs

### Describe the enhancement requested

We use crossbow to run almost all our nightlies and we have several notification reports set up. E-mails and Zulip notifications.

We also have two periodic nightly jobs for the Java and R nightlies on the main Arrow repository:
https://github.com/apache/arrow/blob/157b8f555bdd5bf2fafc875b8c983c8c51a3c936/.github/workflows/java_nightly.yml#L32
https://github.com/apache/arrow/blob/157b8f555bdd5bf2fafc875b8c983c8c51a3c936/.github/workflows/r_nightly.yml#L37

We currently miss the notifications if those jobs fail. We should implement something that allows us to get similar notifications as the ones we get from the crossbow jobs.

This issue has been created as a follow up from the discussion on this issue:
https://github.com/apache/arrow/pull/35478#issuecomment-1541568452

As seen on the comment linked above we could use the [failure condition](https://docs.github.com/en/actions/learn-github-actions/expressions#example-of-failure) on those jobs.

### Component(s)

Continuous Integration, Java, R

Beginne mit .github/workflows/java_nightly.yml und .github/workflows/r_nightly.yml in den verlinkten Job-Abschnitten, prüfe anschließend die Dokumentation zu den Fehlerbedingungen von GitHub Actions und die verlinkte crossbow-Diskussion. Als abgeschlossen gilt die Aufgabe, wenn Fehler aus beiden nächtlichen Jobs Benachrichtigungsberichte erzeugen, die mit den bestehenden crossbow-E-Mail- und Zulip-Benachrichtigungen vergleichbar sind.

Vom Indexierungsmodell aus dem Issue-Text verfasst.