TL:DR Aim Training can make you a god in the long run, but just play the game it'll be better for your time and most likely it will be way more fun than clicking circles.
my thoughts are below:
IMO Aim Training is like going to the gym, you aren't going to see insane improvement if you just do it for a month and if you do it less intensely. For example, Demon1 did his Aim Labs Aim Training 30 mins for each scenario I would count this as high intensity for whoever knows how long but it worked. He even has a few top 10 scores in his playlist scenarios. If he did that playlist for a long time, and it paid off for him it obviously worked.
However, as much as I believe grinding aim training can work in the long run, if you're solely trying to grind Valorant as your single fps game it's probably better to just grind val, obviously you can be as cracked with aim as you can be as long as you grind for it but you still need to learn how to use utility well and gain the most impact out of the utility in-game and also learn how to play well/around your teammates and obviously mastering your movement and the way you peek and clear angles as well as crosshair placement are equally as important as aim so playing the game and working on all these factors equally over time is more worth it.
If you're tryharding this game for whatever reason (you are not going pro but good luck) you should work on an aim training playlist (That geniunely helps don't use gridshot and static dots scenarios only, go look up a playlist from actual credible professional aimers who understand how to fully utilize aim training and to focus on every aspect of aiming) every day and be consistent with it as well as play a lot to gain experience.