Show cone for spotlight is not showing up after the scene is rendered
"Show cone" is just a viewport helper.

Guess you meant a light in volume, look at  Volumetric Spot Light with Cycles

For eevee https://www.youtube.com/watch?v=daCTRzzmpyk