Remove `@sentry-internal/sdk/no-async-await` rule

[AbhiPrasad]

Problem Statement

Although this has bundle size impact on es5 bundles, it should simplify and reduce bundle size for es6 bundles.

Solution Brainstorm

We should prio es6 bundle size, so let's just remove this rule.

End of an era 🫡