Not, in most cases.
> For example if all X pollinators go extinct, could it not potentially leave room for Y pollinators
Not. We would enter in an extinction vortex. Less pollinators mean less seeds, less plants, and the empty space would be filled by Y, the species that Y pollinators search for. X would disappear. And we would lose Z, M and Q also. Is the same that happens with companies that lose their main customers. They became less attractive, not more. To be rescued by the fanbase of a competitor suddenly moving in mass to your product is not likely.
> Would the Earth just be completely screwed?
Not, you can't screw the planet, but would be painful (Mess with nature, brace yourself for nasty surprises. Nasty and unfixable). If we take in mind similar events from our past many people would probably die.