SNP members have backed a resolution rebuking the “devastating consequences” of the UK Government’s “dangerous Brexit obsession”.