Sneak attack is working more or less as intended with regard to which attack = the game engine design limits your options

Yes having disadvantage kills it even if you also have advantage but there are many ways to improve hit chance

Luke Skywalker: I don't, I don't believe it.
Yoda: That is why you failed.