No...
If the spark plug wires are disconnected at the coil packs, there is no spark to the engine and the engine will NOT fire up. The engine, if cranked by the key will turn over with the power of the starter, not enough to make the lifters shoot oil all over the place....
Just be sure to disconnect all (4) plug wires from the coil pack and place them away from any potential "reconnect" at the packs while turning the engine over.
Now, if you forget to disconnect the spark plug wires at the coil and someone fires up the car w/ the valve cover off, sure, you're going to have quite a mess...
The starter will only crank or turn over the engine with the power of itself, not enough to rotate the entire engine mass enough to shoot oil everywhere.