[Doctrine Bridge] simplify session handler

| Q             | A
| ------------- | ---
| Bug fix?      | yes
| New feature?  | no
| BC breaks?    | no because the driver connection could not be used anyway before
| Deprecations? | no
| Tests pass?   | yes
| Fixed tickets | -
| License       | MIT

Use main connection as discussed in #10720