I'm not sure how much the author position matters, other than being first or last, to be honest.
If you are not going to be first author then it's probably not worth the hassle and damage to your professional relationships by querying it. You were right to raise it with your prof first I think, but if nothing changes, it's probably just better to leave it.