[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

Inizia con .github/workflows/java_nightly.yml e .github/workflows/r_nightly.yml nelle sezioni dei job collegate, quindi esamina la documentazione sulle condizioni di errore di GitHub Actions e la discussione collegata di crossbow. Il lavoro è completato quando gli errori di entrambi i job notturni producono report di notifica comparabili alle notifiche e-mail esistenti di crossbow e alle notifiche di Zulip.

Scritto dal modello di indicizzazione a partire dal testo della issue.