Work out the recording time
A 10-second clip at 24 fps needs 240 usable photos. At one frame every 5 seconds, allow roughly 20 minutes on location. Add time for scouting and testing. Check memory-card space using the actual size of a RAW file from your camera.
Leave room between exposures
If your interval timer counts from one exposure start to the next, try a 5 s interval with a 3 s exposure. Some timers count a delay after each shot. Shoot five frames and check the timestamps and files. Long-exposure noise reduction can add another exposure of comparable length. Check your manual if frames are missing.
Reduce flicker in the edit
Lock focus, white balance and exposure for the first sequence. If the aurora brightens enough to clip, stop and start a second sequence with a shorter exposure. Apply consistent base edits to each sequence, export in capture order and review the movement at your final frame rate.