A pilot scheme scrapping peak-time ScotRail fares will end next month following a "limited degree of success".