Sweeney is mired in a brutal offensive slump with just one hit in his last 10 games while serving as Detroit's injury replacement infielder