Cardinality limits are not transactional

[Dav1dde]

Cardinality limits are checked sequentially a later cardinality limit if breached will not 'refund' the cardinality of the prior limits.

This poses a problem not just for the limits themselves but also cardinality reports.

Followup of #3147