If the voters approve the amendments proposed in the petition, does the council have any discretion as to whether to then adopt the charter amendments?

No. G.S. 160A-104 directs that if a majority of votes are in favor of the proposal, the council "shall adopt an ordinance" amending the charter accordingly. The council's responsibility is ministerial.