I have a Pixel 3 running Android 10, so I've been able to play with this a bit. My phone will always use the same MAC to connect to a given SSID. The MAC is different from SSID to SSID, but it's always the same MAC as it was before when I reconnect.
When I look at the Scanning API I don't actually see much impact here. If I connect to Joe's Coffee Free Wifi in my home town, and then I travel and connect to another Joe's Coffee WiFI, my MAC is the same. Joe will be able to know that I am a repeat visitor, and that I just visited a new location to me.
But, the Scanning API is more useful for location than the above example. So let's say I go to a mall. If I don't connect to the Wifi then the Scanning API will report me as a passerby (not connected) and report my location as I move around. I haven't dug deep into it, but I believe even in Android 10 your probe requests use a consistent MAC, so again there's no impact to tacking my movements through the mall. If I do connect to the mall wifi then we're back to the Joe's coffee shop example and the mall will get a consistent view of me regardless of where in the mall I go.
If the property company that owns the mall has other malls, and uses different SSID's in each mall, then that may pose a challenge. But, a lot of these types of wifi deployments will require you to sign in with your social media ID, or email, etc. Once you do that it doesn't matter how often you MAC changes, they always know it's you.