Would DeAndre Hopkins actually make the Titans contenders?

There's no questioning that Titans could use free-agent receiver DeAndre Hopkins. Would his addition be enough to put them over the top?