Personally I do a little bit of all of that (not sound) but I’ve kind of found my niche, or my preferred aspect of game design which is level design and balancing.
I enjoy modelling level props i.e trash cans, crates, buildings etc. I’m not too good with modelling characters, it’s the little details for me.
I know C++, but I’m not super good with it, then on top of the UE programming adds just that much more to learn. I’d prefer Blueprints.
Animation goes with modelling for me, I can do it, but I’d rather get some free animations and add them to my skeleton and do all the stuff in UE.
Texture/Art, meh could go either way with it.
My point of this is:
Try a little bit of everything, you’ll find what you enjoy the most. Or what comes the easiest to you. Just know if you work with a team, you’ll have the areas covered. What you asked about was sort of a broad/vague question, because with programmers you have like main game mechanic coders, you have server programmers (makes sure the servers do what they’re supposed to do) etc. With the Art teams you have, modellers (characters and static meshes, level props. Then you have animators, texture teams etc. You have level designers, maybe level programmers. Then you have the sound guys coming behind with the ambient sounds and what not. You’d also have QA (quality assurance) teams to test different aspects of your games and stuff.
But yeah all in all, there isn’t one way to “design a game” you’ll find your preferred role. Just dive into it, try out everything (some people might not suggest this but it sort of worked for me) and see what you like.