Maybe I've unknowingly picked up a little more intuition about wireless frequency bands and network names, but I don't see any ambiguity there.
To try to rephrase it as I'm reading it:
Different frequency bands (such as the early 2.4GHz, the newer 5GHz, and the newest 6GHz bands) are typically presented as individual networks, even by a single access point. These networks, like any two or more networks, can have their own names.
Apple devices can connect to, and switch as needed between, more than one frequency band from a single access point when offered. Rather than representing this as multiple networks in the interface, Apple devices treat this as "one network." However, it will only do this if the access point is configured such that all of the frequency bands share a network name. When this is not the case, Apple devices represent them as separate networks and ask the user explicitly what to do. This situation is what Apple calls "limited compatibility."