I'll take VSCode "insecure" ssh agent over Emacs Tramp any day of the week because it actually works.

Sometimes you just gotta be pragmatic and use the stuff that works and makes your life easy.