It is possible. I've done it with asylum using Pakrat. Make sure your sounds are in the "team fortress 2\tf\sound" directory. Are you sure your map is setup to play the sound correctly?
If this is your first time logging in after the migration (Feb 8, 2022), you must reset your password to log in. Follow this guide if you're having trouble