How to make the missile behave realistic by looking on the direction it is moving?

I want the missile to behave like this and i tried some solutions from here and here
but they dont seem to work.

I hve this code:

this.rigidbody.useGravity = true; 
rigidbody.velocity = transform.TransformDirection(new Vector3(0, Force, 0));
transform.rotation = Quaternion.LookRotation (rigidbody.velocity);

but it doesnt behave the way i wanted.
Here’s a picture from this 3

alt text

EDIT:

here’s the picture of the orientation of the missile in xyz axes

36093-sasasaaa.png

You could try this:

transform.up= rigidbody.velocity.normalized;

Why don’t you use a transform.LookAt

The Z axis needs to point forward on the missile.