[DOC] Update migrate static for tracing

[knylander-grafana]

PR Description

Adds traces to the migration from static to Alloy documentation.

Additional changes:

• Change name of Grafana Cloud Tempo to Grafana Cloud Traces, since this is the product name
• Change grafana_cloud_tempo to grafana_cloud_tempo

Which issue(s) this PR fixes

Part of https://github.com/grafana/tempo/issues/3648

Notes to the Reviewer

PR Checklist

• [ ] CHANGELOG.md updated
• [X] Documentation added
• [ ] Tests updated
• [ ] Config converters updated

[knylander-grafana]

@clayton-cornell I think we're good with this. Do you want to merge it?