I suspect good ssh support is just so much more necessary for vscode than it was for Emacs when tramp was developed. I do think tramp was also full of generality towards things that are very uncommon these days (various different protocols, ssh workarounds, baud rates, …)