No, it is not dangerous to say academics also have responsibility to consider potential negative impact of their work. I am not talking about vested interests of outside bodies (although research councils certainly set the funding agenda), I am talking about academics as individuals and as a collective group.
There are plenty of historical examples of unethical research work. At the risk of invoking Godwin’s law, you only need to look at scientific research in the Third Reich to show that freedom to research with no responsibility to others caused harm. Yes, there may have been great strides in understanding physiology and neuroscience, for example, great steps towards the ‘truth’, but if that was on the back of torture and death of groups seen as sub-human, we are talking about more than discomfort.
So, of course, academics and researchers have to balance social and moral responsibility against freedom to research. That is why there are ethics codes. For what it is worth, I agree that Bath Spa made the wrong decision but they were not wrong to consider the ethical issues of the matter. They made the wrong decision because of political reasons, not ethical ones.
It is not clear to me whether the Bath Spa researcher appealed the decision, or not. But I am not sure I agree that university administrations as such will not support difficult debates. Rather, I do think that academics who do not agree with specific (eg on the trans agenda) views may be scared to voice dissent, because of the backlash, which is a different thing. And if academics are scared to voice dissent, where is the SJW indoctrination coming from?
There is not usually one accepted ‘truth’; there is debate, revision, consensus, dissent, etc. What is accepted as truth is socially mediated. Thus, even those exercising academic freedom in search of their ‘truth’ have the responsibility to recognise the need for others to debate with them, to recognise there may be limits to what they can reasonably do without causing harm and so on. It is not dangerous to say unfettered academic freedom may cause harms, and that academics have a responsibility to recognise this and act accordingly. The question is who is the arbitrator when there are disputes about ethical boundaries, that was my point.
In the case of Professor Biggar at Oxford, his institution have supported his views. Whether and to what extent they would support an academic airing gender critical views, I don’t know.