What preparation is required for tiling over poorly laid floor boards?
Anything rigid you put over a flimsy structure will be destroyed over time because it won't have the support it needs.  Most tiles (except plastic/vinyl) don't handle bending well.

Self leveling compound doesn't add rigidity, it just makes a smooth top surface.

You need to fix the structure first.  That means going down before you go up.