A sports drink is not the same as an energy drink. Sports drinks generally provide water, carbohydrate, and electrolytes; energy drinks may contain high caffeine and other ingredients. Choose according to session needs, not marketing.
The short answer
Water is enough for most short workouts; a sports drink is useful when prolonged or hot exercise creates a simultaneous need for fluid, carbohydrate, and sodium.
When water is enough
For ordinary lifting or cardio under about an hour in moderate conditions, water is often sufficient. Adjust drinking to thirst, sweat, and environment.
When a sports drink helps
During prolonged hard exercise, heat, heavy sweating, or competition requiring carbohydrate, a sports drink conveniently supplies fluid, sodium, and fuel together.
Too much water is also a risk
Drinking beyond sweat losses can dilute blood sodium. Body mass should not rise during exercise because of overdrinking. Use pre/post-session weight changes to learn your approximate needs.
Practical checklist
Do not test unfamiliar food on an important training or competition day.
Adjust amount and timing to gut tolerance and session goals.
The quality of the whole daily diet matters more than one meal.
References
ACSM Position Stand: Exercise and Fluid Replacement — https://pubmed.ncbi.nlm.nih.gov/17277604/
Nutrition and Athletic Performance — Academy of Nutrition and Dietetics, Dietitians of Canada and ACSM — https://pubmed.ncbi.nlm.nih.gov/26920240/