Add comprehensive steps on what to do for post deploy migration failures

Part of gitlab-com/gl-infra/delivery#2335 (closed)

This change modifies the documentation we have about post deploy migrations to be more comprehensive.