To dream of scoring a goal may indicate that we have set ourselves external targets.

In achieving those targets we may also recognize that the goals we have set ourselves in life are either short-term or long-term and we may need to adjust them in some way.

To miss a goal or target indicates that we have not taken all the circumstances within a situation into account and need, perhaps, to reassess our abilities to achieve. You might like to consult the entry for target for additional clarification.