Remove usage of let_it_be / before_all in Rake specs

What does this MR do and why?

These Rake specs use the deletion strategy so let_it_be / before_all should not be used as this can lead to deadlocks and DB timeouts: #420379 (closed)

This is similar to !128178 (diffs)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.