LLMs with Industrial Lens: Deciphering the Challenges and Prospects -- A Survey