I think you should contact the Student Accommodation team and tell them that you really don't want to live off campus and that you're willing to take any room on campus.
I haven't gotten my accommodation offer yet but I feel very similar to you and am crossing my fingers that I'm not offered off-campus accommodation.
Out of curiosity, when did you apply for accommodation, and what room types did you choose? Also, did you check any of the boxes that might narrow down your accommodation options?
I chose Barnes, Lindsay, and The Oaks ensuite rooms as I really value that extra space and the bathroom, and also because I know there are lots of rooms of each available so thought it'd increase the chance of me getting offered what I want. Also I didn't check any of the boxes.