Clarify language around when to use modals and include non-revertible destructive actions

Clarifies language around the usage of a modal and adds non-revertible destructive actions as a usecase.

Closes https://gitlab.com/gitlab-org/design.gitlab.com/issues/253