Projectile motion problem - why is my approach wrong?

You are trying to solve for the apex (highest point) of the trajectory. When the cannon is fired, gravity causes the projectile to start to fall. This means its path is not a straight line; it is curved (a parabola). Your method will get an answer that is higher in altitude than the true apex of the trajectory.