Split lens logsdb and tsdb tests

[jbudz]

x-pack/test_serverless/functional/test_suites/observability/common_configs/config.group2.ts: 67.7 minutes
x-pack/test_serverless/functional/test_suites/security/common_configs/config.group2.ts: 67.4 minutes
x-pack/test_serverless/functional/test_suites/search/common_configs/config.group2.ts: 66.9 minutes
x-pack/test/functional/apps/lens/group4/config.ts: 60.3 minutes

We would like to get these test groups down to <= 37 minutes as they're currently extending CI completion time by 25-30 minutes. An attempt was made in #199164 but the test suites appear to depend on each other, and runtime could only be reduced by 15 minutes.

[elasticmachine]

Pinging @elastic/kibana-visualizations (Team:Visualizations)

[jbudz]

Dupicate of #198678. I do see it was backlogged, if it's possible to prioritize this it would be much appreciated.