[connector/profilingmetrics] Validate metrics structure with Semantic Conventions guidance

[rogercoll]

• Are current metrics following Otel naming best practices?
• Are we using the correct structure for proper aggregations?
• Should we split frame-type metrics into a separate configuration? refactor(profilingtometrics): generate metrics using mdatagen builder #917 (comment)