Would a sharp or pointed nose cone perform even better?
If
the nose cone is very long, it's performance may actually be even worse. Air
friction along the surface can increase drag! At speeds near or above supersonic,
the sharp pointed nose cone helps because it creates a smaller shockwave.
But with rockets at fairly low speeds (like our water rocket,) there is no clear
advantage to a sharp pointed nose cone.