State and explain the Prime Number Theorem regarding the asymptotic distribution of prime numbers. Discuss the relationship between the prime counting function and the logarithmic integral. Provide a theoretical overview of the significance of the Riemann Hypothesis concerning the error term in this distribution.