A Conservative call to abolish rates for all small businesses in Wales has been voted down by the Senedd amid warnings the tax burden is “hollowing out” high streets.