You've got the right intuition, but let's iron a few things out.
For a minute, forget about the Earth. Just imagine an idealised flat, rigid surface of infinite extent. Impose a uniform gravitational field ##-g \hat{\mathbf{y}}##. The book sitting on the table has its weight exactly canceled by the normal force exerted by the table, to satisfy the equilibrium condition.
If the Earth wasn't rotating, that would be a pretty good local model. In fact, even though the Earth is rotating, the rate of rotation is sufficiently slow that this is an
approximately correct model.
But we might want to think about a different, maybe more accurate, model in which the Earth has non-zero rotational speed. To simplify the description, imagine the table is at the equator. As you correctly deduced, the net force on the book must now be non-zero and pointing toward's the Earth's centre, in order to provide the necessary acceleration ##\rho \omega^2## toward the centre. In other words, the magnitude of the weight will slightly exceed the magnitude of the normal force.
These two descriptions aren't in contradiction, simply because they're not describing the same scenario. The assumptions that underly the two models are different.
