It will work, but a 5 wrap coil of 24 gauge will only be about 3mm or so wide - it will heat up REALLY fast in a DL tank, but the heat will spread across a narrow area giving a high possibility of burning the cotton. Personally I would go at least 8 wraps, but a wrap or two more won't do any harm. 5 wraps is great for MTL where small narrow coils are desirable but they're not so great for DTL when using simple round-wire. If you look at the tub of coils you have many of them are 5 or 6 wraps - but these are either made from several pieces of twisted wire or claptoned wires (core wires with thinner wire wrapped around them) which effectively makes the wire considerably thicker giving better cotton coverage.
8 or 9 wraps sounds like a lot, but 24 gauge is just over 0.5mm thickness so if you add wraps it still won't have excessive mass and will ramp up to vaping temperature pretty fast. Don't be tempted to buy thicker wire than 24 gauge - thicker wire WILL give better cotton coverage but it will take more energy to heat up, and, more importantly, take a long time to cool down - which can make your tank retain heat and get too hot. Thicker gauge round-wires used to be popular for mech mod use - but hardly anyone uses them these days as they are a little bit shit compared to the lower resistance complex coils now available.
24 gauge is the right place to be when you start making your own coils - don't be scared of adding a few wraps as the mod can handle it easily, and if you want to experiment you can always take off a wrap at a time to see what the effect will be - on a regulated mod you won't run into any safety issues because if the resistance goes too low it will give an explanatory error message and refuse to fire.