[Feature]: Atomic updates in SS

[cool-develope]

Summary

In store/v2, SC is atomic and it can roll back to the previous version. But SS is not, and pruning doesn't handle errors properly.

Problem Definition

No response

Proposed Feature

• more appropriate error handling
• Introduce rollback features in the dedicated backend

[tac0turtle]

is this a blocker for final release?

[cool-develope]

good to have, but let's see how robust the current flow is while e2e testing, if needed, will do it

[julienrbrt]

SS is gone since https://github.com/cosmos/cosmos-sdk/pull/22683