On the near-optimality of betting confidence sets for bounded means