> I've never played a wind instrument, but I understand those tend to be tuned to play in certain keys and it can be akward to play in others
It’s been a while since I played (stopped after college), but yes. Wind instruments really only play in one key. It is really rare to have sheet music in a different key and because of that transposing is not a skill that you really need to be successful. You still learn scales… I played one of the few instruments where you were expected to be able to transpose (F horn with some older music in Eb). Even then, while it wasn’t hard, it wasn’t a common skill.
Guitar, string, and piano are an entirely different beast. And that flexibility of scales and keys is probably why you don’t see many wind instruments professionally playing outside of orchestras.