If a Rogue misses first attack but hits with their off hand, do you still get sneak attack damage?

So long as the second attack triggers sneak attack (advantage, adjacent ally), yes!

— Matthew Mercer (@matthewmercer) November 21, 2017