No, Ramos and Pique were both excellent players.
Its not just about the trophies, its the contribution to them, Ramos in particular has played a big role in many of the trophies for RM, you talk of him as if he was a passenger.
Excellent? Yes. But they get overrated.
I have seen folks compare Ramos to Maldini and Baresi, which is a joke. At no point in his career, Ramos was as good as them.
But ofcourse, Ramos is an excellent all round player, very clutch and a Madrid legend no doubt.
About Pique, he has glaring weaknesses in his game although he was great in his prime and very good on the ball. Pique has admitted that the PL didn't suit him at all and he found it very difficult. He barely got games ahead of Vidic and Rio. It's because of the weaknesses he had against pace and quick feet. A bit similar to Puyol except Pique was more talented and Puyol had better mental attributes.