The original plans were for a tunnel between SI and Brooklyn. Still probably the most realistic of any plan though it does lose the benefits of a direct connection to Manhattan.
We should be asking “why not both?” but unfortunately NY construction costs are inflated so ridiculously we can’t even afford one let alone get politicians with a strong enough backbone to support these common sense projects that would alleviate strain on NYC housing stock.