Exactly, he isn't going to win any academy awards, but as far as worst, not by a long shot. It no like he's Hallmark or Soap Opera level bad.
His career is definitely over... He's too big and too handsome, it's not like you can fit him in any story. And now he's aged, so even for superhero stuff they won't hire him because in 10 years he'll be 50. His only salvation is dropping those muscles like McCounaghey did. He's got a lot of charisma he can use in his favor. As of right now there are only embarrassments available for him like Argylle. The same with Momoa, John Cena, The Rock... Too big, too old.