I'd allow it. Even ignoring the moving planet argument (which might not be true in a fantasy setting if everything rotates around the "Earth"), it's the easiest way to handle it. Having every spell effect fixed rather than mobile might result in wonkiness (creating a Wall of Force to sweep everyone from the deck of a ship). If it's done on a case-by-case basis, players will never know what to expect until the DM makes a firm ruling, plus that could be a lot to remember. Will Evard's Black Tentacles move with a mobile platform or is it fixed? If all spells are relatively mobile, ship combats play out similarly to land combat, without the need for rulings on where and how far fixed spells will "drift".