Correct. Sadly:
- Apple changed Sonoma such that getting the wifi name requires Location permission.
- Apple did not change Sonoma such that requesting the wifi name prompts for Location permission.
- Apple has provided no way to manually add Location permission.
See: