Uncovering the Limitations of Query Performance Prediction: Failures, Insights, and Implications for Selective Query Processing