Check if `prismaIntegration` can be enabled by default

[mydea]

Description

We used to not include the prismaIntergation by default, because there were issues with CJS builds and it.
We should check if this is still the case, and otherwise try to enable this by default for v9.

[mydea]

@lforst do you know if we could actually do this now on v9? Or is this still breaking cjs users, possibly?

[lforst]

I think we still depend on Prisma shipping the package in ESM. I opened an upstream PR: prisma/prisma#26918

[lforst]

The PR was merged. This is blocked until the PR is released but then we can update the instrumentation package and merge #16073