Berman wanted to set the first season on Earth and make it more contemporary and the network rightly called him out on that. The shows set in the 24th century were all huge successes (some more than others) so why would you wanna change that?
Watch Demons/ Terra Prime, then you will understand it. It took the Reeves-Stevenes to prove that Berman's concept was totally right and that the risk-averse executives were wrong.
I am not against criticizing Berman but either he stayed in the franchise too long or he had too innovative ideas. You cannot have it both ways.
Talking about innovative ideas, B&B came up with the 22nd century Vulcans, the Andorians, the conflicts among the future four founding members of the Federation and a show with a decent retro feeling. Sure, it felt too often like a 24th century show and wasn't retro enough but I just went over that in the previous paragraph, you have the studio to blame for that.