How to show a tracked video in 3D view?
For the sake of completeness on this site, I am extending my comments to an answer.

To view the footage from the motion track in the camera, go into camera view Numpad 0, and then add a new background image. To do this go to the bottom of the properties panel, check background images, add a new one, and then set it to movie clip and select your clip.