Cult classic musical Rocky Horror Show has arrived in Cardiff with a bang.