[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

从链接的 job 部分开始查看 .github/workflows/java_nightly.yml 和 .github/workflows/r_nightly.yml，然后查阅 GitHub Actions 失败条件文档以及链接的 crossbow 讨论。当两个 nightly job 的失败都能生成与现有 crossbow 电子邮件和 Zulip 通知相当的通知报告时，即视为完成。

由索引模型根据 Issue 内容生成。