As a shameless plug for Canon (there's absolutely nothing wrong with Nikons by the way), the Canon T1i also shoots video if you weren't already aware it existed (as does the 5dMII and 7D, but they're much more expensive). As for the lens, no, that is not considered a macro lens. The big thing to look for with macro lenses is a 1:1 magnification factor. That particular lens has a 1:3.9. In other words, at the closest focusing distance, the object your photographing will be just a tad larger than 1/4th its (as opposed to 100%) actual size on the sensor. Also, if you haven't read up on aperture, you may want to do so. That's a fairly "slow" lens, so it won't be very good for low light situations or freezing very high speed action. Of course, "faster" lenses are significantly more expensive, so that may not be an option.
I think your best options for macro lenses are what I mentioned in my above post. Companies don't make very many different true macro lenses, and I believe they're always prime (i.e. one focal length) lenses. So your choices are somewhat limited, and although they're generally not horribly expensive, they're definitely not cheap.