Classically, Grothendieck's motives are only the pure motives, meaning abelian-ish things which capture the (Weil-cohomology-style) $H^i$ of smooth, projective varieties. To see the relationship with motivic cohomology, one should extend the notion of motive so that non-pure (i.e. "mixed") motives are allowed, these mixed motives being abelian-ish things which capture the $H^i$ of arbitrary varieties. The main novelty with mixed motives is that the (conjectural) abelian category of them is not semi-simple -- in fact every mixed motive should be a (generally non-trivial) iterated extension of pure motives, these extensions essentially coming from compactification and resolution of singularities, as in the story of mixed Hodge structures.
Then once one thinks of mixed motives, a natural direction of study (or speculation, as the case may be...) is that of determining all possible extensions (or iterated extensions) between two motives. And that's what motivic cohomology is, essentially: the study of these Ext groups. More formally, every variety $X$ should determine an object $C(X)$ in the bounded derived category of mixed motives, collecting together all the various mixed motives $H^i(X)$, and the $(i,j)^{th}$ motivic cohomology of $X$ is (up to twisting conventions) the abelian group of maps from the unit object to $C(X)$ \ $[i](j)$ (the $j^{th}$ Tate twist of the $i^{th}$ shift of $C(X)$) in the derived category of mixed motives.
Now, there are a few points to make here. The first is that, though the above motivation and definition of motivic cohomology rely on an as-yet-conjectural abelian category of mixed motives, one can, independently of any conjectures, define a triangulated category which, as far as anyone can tell, behaves as if it were the bounded derived category of this conjectural abelian category. The most popular such definition, because of its simplicity and relative workability, is Voevodsky's. So the basic theory and many basic results on motivic cohomology are unconditional.
Another thing to say is that, as always, matters with motives are illuminated by considering realization functors. Let me single out the $\ell$-adic etale realization, since its extension from pure to mixed motives is straightforward (unlike for Hodge structures): any mixed motive, just as any pure motive, yields a finite-dimensional $\ell$-adic vector space with a continuous action of the absolute Galois group of our base field. It then "follows" (in our conjectural framework... or actually follows, without quotation marks, in Voevodsky's framework) that the $(i,j)^{th}$ motivic cohomology of X maps to the abelian group of maps from the unit object to $C^{et}(X)$ \ $[i](j)$ in the bounded derived category of $\ell$-adic Galois representations. But this abelian group of maps is just the classical (continuous) $\ell$-adic etale cohomology $H^i(X(j))$ of the variety $X$, making this latter group the natural target of an $\ell$-adic etale "realization" map from motivic cohomology.
So here comes the third point: note that this is the etale cohomology of $X$ itself, not of the base change from $X$ to its algebraic closure. So this etale cohomology group mixes up arithmetic information and geometric information, and the same is true of motivic cohomology in general. (Think especially of the case $X=pt$: the motivic cohomology of a point admits a generally nontrivial realization map to the $\ell$-adic Galois cohomology of the base field.) For example, it is expected (e.g. by Grothendieck -- see http://www.math.jussieu.fr/~leila/grothendieckcircle/motives.pdf for this and more) that for an abelian variety $A$ over an ``arithmetic'' base field $k$, the most interesting part of the motivic cohomology $H^{(2,1)}(A)$ (again my twists may be off...), by which I mean the direct summand which classifies extensions of $H^1(A)$ by $H^1(G_m)$, should identify with the rationalization of the abelian group of $k$-rational points of the dual abelian variety of $A$, the map being given by associating to such $k$-rational point the mixed motive given as $H^1$ of the total space of the corresponding $G_m$-torsor on $A$. And in this case, the above "realization" map to $\ell$-adic etale cohomology is closely related to the classical Kummer-style map used in the proof of the Mordell-Weil theorem.
So in a nutshell: motivic cohomology is very related to motives, since morally it classifies extensions of motives. But it is of a different nature, since it is an abelian group rather than an object of a more exotic abelian category; and it's also quite different from a human standpoint in that we know how to define it unconditionally. Finally, motivic cohomology realizes to Galois cohomology of a variety itself, rather than to the base change of such a variety to the algebraic closure.
Hope this was helpful in some way.
Best Answer
I don't know much about this stuff, so instead of answering the question, I try to formulate more precise questions, in the hope someone else will take up these questions:
One of the main reason to look for cycles is that they give realizations (their fundamental class) in all cohomology theories, which happen to have special properties (e.g., are Hodge cycles or Tate cycles), and anytime you see a Hodge (or Tate) cycle in cohomology, you expect that it comes from an algebraic cycle (the Hodge or Tate conjecture) and hence similar phenomena should occur in all cohomology theories (i.e., there is a Hodge (or Tate) cycle in all realizations).
Now, if the following were true:
1) Any 'derived algebraic cycle' gives rise to virtual fundamental classes in all cohomology theories, which again are Hodge or Tate cycles.
2) It is not clear that the virtual fundamental classes of 'derived algebraic cycles' are already fundamental classes of real algebraic cycles,
then one might formulate a 'derived' Hodge or Tate conjecture, which would have the same consequences.
Your question has another aspect, which regards a possible framework for working with these motives; I leave this aside as I understand even less about how this should work.