The short answer
Most people change their alarm sound because the old one stopped working. It usually has not — you have habituated to it. Your brain learns to categorise a familiar, consequence-free sound as unimportant and filters it out during light sleep.