Like most things, It depends...
Yes, as a resident you will be exposed to all of the types of sports cases you listed above. You will hopefully feel comfortably doing straight forward knee/shoulder arthroscopy as well as meniscectomies, rotator cuff repair, maybe even ACL repairs. If you are going to be a general orthopod in the community then you probably don’t need a sports fellowship to take care of straight forward sports injuries in not so high level athletes.
On the other hand, if you want to market yourself as a “fellowship trained” Ortho surgeon who specializes in sports related injuries. You darn well better go do a fellowship if you want to get a job in a competitive market and certainly if you ever hope to work on high level athletes. You also need the extra year focused SPECIFICALLY on SPORTS-RELATED injuries of the knees, hips, ankles, shoulders, etc. In your 5 year residency you will be exposed to these procedures, but you also do so much spine, adult recon, trauma, peds, etc that is NOT sports related. A typical ortho residency may only boil down to 3-6months where you are working on a sports service that specifically treats sporting injuries in athletes. How much of that surgery you actually do and feel comfortable doing on your own out in practice will depend on the residency program and on you.
Doing a 1 year sports fellowship would therefore double or even quadruple your sports experience. You would hone your arthroscopy skills, physical exam, overall knowledge/confidence, etc. It is also a critical time to make connections and get the recommendations you need to land the job you want as the “sports guy” for some ortho group.
The same principle holds true for the other subspecialties in orthopedics which are: hand, peds, joints, upper extremity, spine, foot/ankle, and trauma. I believe around 90% of people do a fellowship now and the ones who don't typically work in rural settings. Nice thing is that all fellowships are just 1 yr. That means after 6 total years of pgy training you are a fellowship trained subspecialist. When you consider that most medical and gensurg fellowships are 2-3 years (so 6-8 years total), it's really not a bad deal.