"How come a great folk singer managed to turn himself into a very ordinary rock singer ?".
Simple. It's easier to make a living as a very ordinary rock singer than as a great folk singer - but Brady was never "ordinary" in anything he ever did. Plus presumably Paul Brady wanted to play his own music, rather than, as Nigel Kennedy once put it, "music by dead people".