The “red alert” sent out by the Spanish government caused an alarm to sound from people’s devices, described as “extremely painful to the ears” and sparked panic ahead of todays floods in the area