d9780 I need to disconnect/forget the wifi network and reconnect to get. New randomized Mac address
That is true on regular Stock Android. On GrapheneOS, the default is a new MAC address per connection, i.e. if you disconnect then connect again, your phone will use a new randomly generated MAC address.
d9780 is my Mac address different for each profile
I believe the same MAC and IP address are shared globally. If you want to get a new IP for a new profile, maybe use airplane mode before switching.
d9780 My question is, is my Mac address different for each profile I am using in the pixel 6, or are they the same and it could lead to identifying the device location when I am using a different more secure profile bc my Mac address is the same as the mc address I was using in a less secured ' Google apps' profile?
User installed apps can't get hardware IDs, so if you have Google apps installed, just use a VPN and then as long as another profile uses a different IP / VPN server then there's no way they can correlate one profile's traffic with another's.
All they can see is the public IP address you're connecting to their servers with. So, even if different profiles used different MAC addresses, your public IP would be the same. So, still, a VPN would help you isolate different profiles' traffic.