Parse process config file based on the real file's type and not the extension

**Describe the bug**
Cloudbeat failed to parse a Kubelet process config file as it lacks the supported extensions (JSON/YAML), even though the file is indeed a yaml file.

```
09:33:10.542 elastic_agent.cloudbeat [elastic_agent.cloudbeat][info] Using etc/eks/ecr-credential-provider/ecr-credential-provider-config as a configuration file for process kubelet
09:33:10.548 elastic_agent.cloudbeat [elastic_agent.cloudbeat][error] Failed to parse file configuration for process kubelet, error - type is not supported
```

**Preconditions**
8.7.0-SNAPSHOT
Install the KSPM - EKS integration

**To Reproduce**
Write the exact actions one should perform in order to reproduce the bug.
Steps to reproduce the behavior:
1. Install agents and observe fleet UI logs, the error should appear.

**Expected behavior**
Cloudbeat should be able to parse YAML/JSON files even if the file's name lacks the proper extension, which can be handled by detecting the actual mime type of the file.