It is has to be transported and stored doesn't it?
Yes. In large steel tanks.
Do you campaign against fuel tanks driving around? They contain far more dangerous fluids than flowback water.
As mentioned already all chemicals added to the water are non toxic AND because of the extremely high levels of regulation in O&G it is considered low level radioactive waste and as such needs to be disposed of at licences disposal locations.
Both cuttings (the rock brought up while drilling) and flowback water are considered radioactive because of NORMs (naturally occurring radioactive minerals) within the rocks. Just to clarify how radioactive the rock is, it's the same stuff people hike over and picnic on in national parks and uplands all over the country. The same radioactivity as the slate people put on their roofs and spread all over their gardens but because it is from a well it is classed as mining waste and comes under very prior mentioned strict regulations.
As for the flowback water radioactivity, its so radioactive you could drink it neat for a year and still not hit the yearly radioactivity limit IIRC*.

The details of the flowback water produced by Cuadrilla are available online if you want to check that out yourself.
TBH much flowback water is now treated on site and reused in subsequent wells so there isn't actually much to tank away.
* to clarify, that's maximum yearly dosage for a radiation worker (eg someone working at a nuclear power station). Obviously most people aren't going to drink neat flowback water so it's a bit irrelevant, but it does show how in radioactive the water actually is.