No no no, you will need other insurance too. Collision waiver is only a very small portion that you will get for free from lots of places. What if you hit someone or got hit by some other car? What if your car is stolen?
You'd better buy the insurance from the rental agent. Otherwise you are simply heading for trouble.