### Elasticsearch Version

8.8.1+ but probably all versions

### Installed Plugins

_No response_

### Java Version

_bundled_

### OS Version

cloud

### Problem Description

This is a follow-up of [#97370](https://github.com/elastic/elasticsearch/issues/97370). 

In a case where disk spaces are reaching limits, if ILM suddenly tries to move a lot of hot shards to cold/frozen shards, it can tip the cluster health to RED because a lot of cold/frozen shards may be created and stay unassigned as long as there is not enough disk space. However, this is not a suitable indicator for service unavailability, since the data is still safely in the respective hot shards that are becoming cold/frozen, and will remain there until the cold/frozen shards are assigned so that searches can still search them.

Thus the [Health Report API](https://www.elastic.co/guide/en/elasticsearch/reference/8.8/health-api.html) should not return RED for unassigned cold/frozen shards of ILM moves.

### Steps to Reproduce

In a case where disk spaces are reaching limits, if ILM suddenly tries to move a lot of hot shards to cold/frozen shards, it can tip the cluster health to RED because a lot of cold/frozen shards may be created and stay unassigned (as long as there is not enough disk space).

### Logs (if relevant)

_No response_
server/src/main/java/org/elasticsearch/cluster/routing/allocation/ShardsAvailabilityHealthIndicatorService.java
if (dataTierAllocationResults.stream().allMatch(hasDeciderResult(ShardsLimitAllocationDecider.NAME, Decision.Type.NO))) {
            List<Diagnosis.Definition> diagnosisDefs = new ArrayList<>();
            
            List<RoutingNode> dataTierRoutingNodes = clusterState.getRoutingNodes()
                .stream()
                .filter(routingNode -> dataTierNodes.contains(routingNode.node()))
                .toList();
            
            Integer clusterShardsPerNode = clusterService.getClusterSettings().get(CLUSTER_TOTAL_SHARDS_PER_NODE_SETTING);
            Integer indexShardsPerNode = INDEX_TOTAL_SHARDS_PER_NODE_SETTING.get(indexMetadata.getSettings());
            assert (clusterShardsPerNode > 0 || indexShardsPerNode > 0) : "shards per node must exist if allocation decision is NO";
            
            boolean clusterShardsPerNodeShouldChange = false;
            if (clusterShardsPerNode > 0) {
                int minShardCountInTier = dataTierRoutingNodes.stream()
                    .map(RoutingNode::numberOfOwningShards)
                    .min(Integer::compareTo)
                    .orElse(-1);
                clusterShardsPerNodeShouldChange = minShardCountInTier >= clusterShardsPerNode;
            }
            boolean indexShardsPerNodeShouldChange = false;
            if (indexShardsPerNode > 0) {
                int minShardCountInTier = dataTierRoutingNodes.stream()
                    .map(routingNode -> routingNode.numberOfOwningShardsForIndex(indexMetadata.getIndex()))
                    .min(Integer::compareTo)
                    .orElse(-1);
                indexShardsPerNodeShouldChange = minShardCountInTier >= indexShardsPerNode;
            }