I share the frustration. But apparently small phones don't sell.
It's all relative.
If Google sold five million iPhones Mini it would be considered a smash hit. But because it's Apple it's considered a flop because of the ridiculous sales numbers of their other models.
The problem is that everyone believed Tim Cook when he claimed that this is a failure.
iPhone 3GS
Galaxy S3
Sony XZ1 Compact
iPhone SE 2016
iPhone SE 2020
iPhone SE 2022
Unihertz Atom
The various Mini models accounted for 3 to 6% of sales, which was still millions of units.