You have to be faithful to what you genuinely believe the scripture teaches. Simple as that. If you don't believe it teaches what the church teaches, then that's going to cause conflict eventually.
And bottom-line, you have decide what is a fundamental issue, and what is negotiable. Like, we wouldn't be happy with any sexual activity before marriage (and yeah, given that snogging is a mighty effective prelude to the main act, that would include snogging). But if someone else thought snoggin was ok, as an example, that would be one seriously inane thing for us to fall out over, iyswim.
But there are things which are pretty major worldview things - like the inspiration of the bible, what the gospel is, and so on, which can cause serious conflict.
Essentially, it boils down to what is going to actually cause a problem for you. Plenty of people hold to views you will disagree with, and you can manage to rub along fairly well with them. But if it becomes something personally relevant to your life, things get trickier.
I wouldn't change church myself, but you don't want to listen to me at the moment, I'm a dreadful example.