The cabin crew can usually hear the alarm so I guess front row passengers should be able to.
Definitely, it's clearly audible back to at least the 3rd row, though not back at the overwing exits. I always notice it when near the front.
I'll try not to mutter rude things about the crew if it may be that the automatics smacked it onto the runway