### Summary

I'm running a task with both `async:` and `become: true` (`become_method` is `sudo`). The implicit `async_status` always fails to retrieve the status since it cannot access the status file, which is owned by the privileged user.

This is very likely due to #74837, since now `async_status` no longer executes a module on the target, but tries to use the connection plugin to retrieve the status file. Since the connection plugin does not use the become plugin, it is not able to read the status file.

CC @bcoca 

### Issue Type

Bug Report

### Component Name

async_status

### Ansible Version

```console
devel
```


### Configuration

```console
-
```


### OS / Environment

Linux

### Steps to Reproduce

```yaml (paste below)
    - name: Run database update
      command: sleep 1m
      become_user: root
      become: true
      async: 10
      poll: 20
```


### Expected Results

After one minute, the task completes.

### Actual Results

```console
<x.x.x.x> FETCH /root/.ansible_async/115781608644.27380 TO /home/me/.ansible/tmp/ansible-local-389716fh7xxnq9/_async_115781608644.27380c_or_953
<x.x.x.x> SSH: EXEC sftp -b - -o ControlMaster=auto -o ControlPersist=300s -o StrictHostKeyChecking=no -o 'IdentityFile="/path/to/key.pem"' -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o 'User="dybuster_admin_ansible"' -o ConnectTimeout=20 -o ControlPath=/home/me/.ansible/cp/8bc7ae9d88 '[x.x.x.x]'
[WARNING]: sftp transfer mechanism failed on [x.x.x.x]. Use ANSIBLE_DEBUG=1 to see detailed information
<x.x.x.x> SSH: EXEC scp -o ControlMaster=auto -o ControlPersist=300s -o StrictHostKeyChecking=no -o 'IdentityFile="/path/to/key.pem"' -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o 'User="dybuster_admin_ansible"' -o ConnectTimeout=20 -o ControlPath=/home/me/.ansible/cp/8bc7ae9d88 '[x.x.x.x]:/root/.ansible_async/115781608644.27380' /home/me/.ansible/tmp/ansible-local-389716fh7xxnq9/_async_115781608644.27380c_or_953
[WARNING]: scp transfer mechanism failed on [x.x.x.x]. Use ANSIBLE_DEBUG=1 to see detailed information
<x.x.x.x> ESTABLISH SSH CONNECTION FOR USER: dybuster_admin_ansible
<x.x.x.x> SSH: EXEC ssh -o ControlMaster=auto -o ControlPersist=300s -o StrictHostKeyChecking=no -o 'IdentityFile="/path/to/key.pem"' -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o 'User="dybuster_admin_ansible"' -o ConnectTimeout=20 -o ControlPath=/home/me/.ansible/cp/8bc7ae9d88 x.x.x.x 'dd if=/root/.ansible_async/115781608644.27380 bs=65536'
<x.x.x.x> (1, b'', b"dd: failed to open '/root/.ansible_async/115781608644.27380': Permission denied\n")
<x.x.x.x> Failed to connect to the host via ssh: dd: failed to open '/root/.ansible_async/115781608644.27380': Permission denied
[WARNING]: piped transfer mechanism failed on [x.x.x.x]. Use ANSIBLE_DEBUG=1 to see detailed information
<x.x.x.x> ssh_retry: attempt: 1, caught exception(failed to transfer file to /root/.ansible_async/115781608644.27380 /home/me/.ansible/tmp/ansible-local-389716fh7xxnq9/_async_115781608644.27380c_or_953:

dd: failed to open '/root/.ansible_async/115781608644.27380': Permission denied
) from cmd (/root/.ansible_async/115781608644.27380...), pausing for 0 seconds
```
The `dd` method is then tried again and again, always with `dd: failed to open '/root/.ansible_async/115781608644.27380': Permission denied`.
```


### Code of Conduct

- [X] I agree to follow the Ansible Code of Conduct
sample: '360874038559.4169'
finished:
  description: Whether the asynchronous job has finished (C(1)) or not (C(0))
  returned: always
  type: int
  sample: 1
started:
  description: Whether the asynchronous job has started (C(1)) or not (C(0))
  returned: always
  type: int
  sample: 1
stdout:
  description: Any output returned by async_wrapper
  returned: always
  type: str
stderr:
  description: Any errors returned by async_wrapper
  returned: always
  type: str
erased:
  description: Path to erased job file
  returned: when file is erased
  type: str
'''
import json
import os
from ansible.module_utils.basic import AnsibleModule
from ansible.module_utils.six import iteritems
from ansible.module_utils._text import to_native
def main():