[Backport 2.x] Snapshot _status API to return correct status for partial snapshots (#12812)

[Backport 2.x] Snapshot _status API to return correct status for partial snapshots (#12812) #29236