It doesn't change the look of minecraft too much at all. Only, there are many subtle DBZ related changes.
Here are some screenshots of some of the texture changes:
Title Screen (Comes with many, many more splashes)
The full moon
Most block changes and paintings
First Person Bow
Most drastically changed mobs:
Some cats are Korin
Angry wolves become the Great Ape
Some villagers look somewhat human
Creepers are Chiaotzu
Slimes are Buu
Zombies are Saibamen
Iron Golems are Android 19
These are most of the differences in the texture pack.
There are also many differences in other things as well, that go along with the original DBZ map, such as GUI changes, greener grass, and all armor is re-skinned.
Banner to help support the map:
This is a Machinima made in the map, using this texture pack.