[DOC] Update Cloud Profiles docs for Agent > Alloy

[knylander-grafana]

Review the Pyroscope and Cloud Profiles documentation to use Alloy instead of Agent.

Reference: #3272, https://github.com/grafana/pyroscope-squad/issues/102

Tasks

Beta Give feedback

1. Review existing documentation to see which pages reference Agent, include the set up and any config pages.
2. Are example configs in static or flow (river)?
3. Update set up pages
4. Update other pages
5. Verify with the Alloy writer

[knylander-grafana]

Data sources for profiles:

Cloud Profiles needs to be update:

1 - Sending profiles when you add a new Pyroscope data source still references Agent in the text and in the diagram. For example, https://grafana.com/orgs/kimnylander/hosted-profiles/366725#sending-profiles (ref: https://github.com/grafana/pyroscope-squad/issues/102)

2 - Hosted profiles data source is up to date.

3 - Pyroscope data source is okay. The text for the steps has been updated to match the newer UI for 11.2 and in Cloud.