This is common in certain verticals, think e-commerce organizations with relatively niche products like replacement auto parts. They (the big fish being Autozone and Advance) go through the effort of having separate pages for each model year and the part name-- even when parts are interchangeable across multiple years. There are tools sold on a commission basis like http://www.youramigo.com that automatically create these pages, but they never seemed to get much traction.
The largest issue is Google's crawl budget. With limited domain authority, it will be hard to get xx,xxx+ pages indexed without a meaningful number of quality backlinks. Low MSV queries are even tougher if you don't rank #1, too, so using GSC to A/b test titles/descriptions CTRs will be super helpful. On-site interlinking will also be another easy way to juice visibility.
This is exactly what I see. Run and e-commerce site with 175k different product pages. Each have a ton of differentiation and keywords. Huge investments is page metadata and sitemap haven't resulted in Google ever indexing more than half the pages.
Do you have internal links to those pages directly from other pages linked from your homepage? Like a rotating popular products section? We added this recently and we went from having 5% indexed after 6 months to 90% 6 weeks later.
The largest issue is Google's crawl budget. With limited domain authority, it will be hard to get xx,xxx+ pages indexed without a meaningful number of quality backlinks. Low MSV queries are even tougher if you don't rank #1, too, so using GSC to A/b test titles/descriptions CTRs will be super helpful. On-site interlinking will also be another easy way to juice visibility.