That’s a whole world 😁

Yellow-orange-red are the warmest colors, cyan the coldest (in oilpaint white is colder but that’s a whole thing in itself), I recommend Florent Farged colorwheel (it’s free, and he has youtubes explaining a lot about color):

An important thing is that the warmness or coolness is almost only relative to surrounding colors! So to make that fireball pop, make it so that naturally its surroundings are darker, colder, less ontense in color, … And so on! There is a rembrandt painting where the fire is dull but so intense because the darkness around it…