[pkg/ottl] Add e2e test for profiles in ottlfuncs

[rockdaboot]

Component(s)

pkg/ottl

Describe the issue you're reporting

We have no e2e test for profiles in ottlfuncs, which prevents improvements and bug fixes to be merged. This in turn blocks further progress on profiles support for the transform processor.

Reference: #39416

Requested e2e tests: #39416 (comment)

Todo

Add tests based on profiles in pkg/ottl/e2e.

[github-actions]

Pinging code owners:

• pkg/ottl: @TylerHelmuth @evan-bradley @edmocosta

See Adding Labels via Comments if you do not have permissions to add labels yourself.