[proxy] delete console-redirect hardcoded logic

[conradludgate]

In console-redirect (psql -h pg.neon.tech), all production workloads should go via pg-sni-router, and not direct to compute. I believe this is already the case, but would need to confirm.

Tests might currently run direct to compute, this should be addressed.

Ref: https://github.com/neondatabase/neon/blob/b23e75ebfe6b6991cdff94d7ce1f627997db797e/proxy/src/auth/backend/console_redirect.rs#L212-L220

[conradludgate]

Prior attempt: https://github.com/neondatabase/neon/pull/11765 Looks like it is used in e2e tests as well.

[zenithdb-bot-dev[bot]]

This issue was moved to Jira: LKB-1521