Fix regression on storage rollback causing repositories to report as 404

What does this MR do?

Fix a regression introduced by a previous refactor. You can read the details of the cause here: #211452 (comment 314736687)

This also improves specs by adding integration cases that can catch the previous regression

Does this MR meet the acceptance criteria?

Conformity

• Changelog entry
• Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides
• Separation of EE specific content

Closes #211452 (closed)