VFX is generally used as an ultimate generic term, you’re right.
It’s art though and art is subjective. I don’t think there will ever be a course that teaches everything for that very reason.
Tools will come and go but art and animation principles will remain the same. VFX has a wide spectrum of styles, approaches, that the cascade into game genres, camera perspective and so forth.
If you enjoy a particular aspect or you’re curious about another, lean on those areas and problem solve and solve for the art and experience within the game. For example, what you find interesting about shaders or fluid simulations might be a traditional animators nightmare and visa versa. The path of least resistance.
What I find exciting about this course, so far its providing techniques to help communicate principles. Sure it’s Photoshop but the same knowledge could be applied to Krita, etc.
Be it a realistic game or anything with a defined look, if you can take a screen grab, paint over it and communicate to anyone; your idea is going to be a lot easier to approach.