In addition to setting the sound in Windows Sound settings, I had to also turn on a setting in Visual Studio itself.
Tools > Options > Test > General > Sound Notification > turn on "Play a sound when tests finished running"
This is Visual Studio Professional 2022, Version 17.14.6 (June 2025)