Do I need to also use the Workouts app?

No. You should not use the Workouts app with SmartGym. SmartGym can already track all your health data for you. Also, Apple Watch only supports one workout session at a time. So, using the Workouts app with SmartGym will probably result in a bad tracking.