Variety has confirmed with sources that Hardy will not appear in a third season of the Paramount+ crime drama