The rain and storm activity largely held off in Brisbane as revellers heralded in the new year with fireworks at Southbank.