Cavill will be fine for the next couple of years at least. The general audience likes him. He has made some terrible choices though. But nowadays there is not one actor, Cruise aside, that can sell a movie on name alone. Audiences are smart, even though studio seem to always forget that.
With Argylle his only fault was that he agreed to be in a terrible movie for 10 minutes that media sold as HIS movie. WOM was toxic and he could have easily avoided that.
I mean Warfare is only his second post-Witcher movie and is getting good wom out of the gate. Not his fault that Lionsgate just decided to dump it.
IMO in the right role the audiences will be more than willing to watch his movies. Hopefully Highlander, which on paper sounds promising, will be it. And then there is a rumor that soon we will see him in a Marvel movie ?