Test stream/auto_flush.cpp marked as XFAIL on HIP NVIDIA

### Describe the bug

The E2E test `Basic/stream/auto_flush.cpp` is marked as XFAIL on HIP NVIDIA.
It is unclear how to verify or even reproduce this since we don't test on HIP NVIDIA platforms so setting the help wanted label. One of the main purposes of this issue is to have a tracker for these XFAIL's.

### To reproduce

`llvm-lit -v sycl/test-e2e/Basic/stream/auto_flush.cpp`

### Environment

- OS: Any
- Target device and vendor: HIP NVIDIA
- DPC++ version: [e.g. commit hash or output of `clang++ --version`]
- Dependencies version: [e.g. the output of `sycl-ls --verbose`]

### Additional context

_No response_