Just a bit of looking under the hood complexity. Wi-Fi bands and network SSID names are different from actual networks at the LAN level.
Yes, different Wi-Fi bands or SSID names can be mapped to different networks, and some SSID’s can have station isolation turned on (aka “guest mode” where each wireless device can only communicate to the Internet but not see or talk to other wireless devices), but there is a lot of nuance to all of this.
There is also legacy issues with the original Wi-Fi spec for 2.4 GHz devices that imposes additional bandwidth limitations and reliability issues. Later versions of 2.4 GHz spec fixed most of those really bad issues (like a broken device hogging the airwaves preventing any other device from communicating) but there are bad devices out there which is why some geeks prefer to avoid 2.4 GHz devices completely or create separate SSID wireless networks for them.
However, soap-box on, the inability to onboard new smart home devices to the 2.4 GHz Wi-Fi without turning off or suspending 5 GHz Wi-Fi networks with the same SSID, is really a basic bug in the implementation of many smart devices firmware which the manufacturers do not have the will to fix.
Band-steering, often confused with this issue, is not the same thing and does not solve the same problem.
The root cause of all these issues is that Wi-Fi gives final (and often the only authority) to make all these technical decisions in the hands of the end device, not the router or Wi-Fi infrastructure.
Your iPhone, laptop, or smart device has the final “say” in which access point or which speed band to connect with and which one it thinks is “closer” or “best”, regardless of what the Wi-Fi equipment, which has a global view of all traffic, bandwidth rates, channel usage, etc. thinks.
In practical terms, imagine if driving on public roads each driver/car can choose to do anything they like. Traffice lights, on-ramps, off-ramps, lanes, are all “advisory” but not “compulsory”. That’s the situation with Wi-Fi.
Band-steering is a feature where the Wi-Fi system recommends to the end device that it move to a different frequency band or access point, but the device is under no obligation.
It’s like driving with a partner in the passenger seat telling you to change lanes because they think the “other” lane is faster, but you have the ultimate authority to follow their advice or ignore it.