Rethinking the Uncertainty: A Critical Review and Analysis in the Era of Large Language Models