There’s been a similar question about this:
maybe it’ll help you
Also, if it’s possible, you can try to do the same but in an Eevee one. There’s a good tut about how to achieve a good fog result with an Eevee:
Cheers