I know this is a while ago, but I have a lead for you as I think I've just fixed this issue at my end (same scenario github codespaces with Snowflake, using SSO.

I changed this setting in vscode from "hybrid" to "process" (note that process reports as being the default)

remote.autoforwardportsource