[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 內容生成。