If I recall correctly only missiles with a warhead onboard will self-destruct at the end of their endurance. Missiles without it should simply become buoys when they run out, and engine-less missiles are naturally buoys.
Quick note: If you fire a missile at a waypoint, the waypoint counts as the missile's target. Don't try to piggyback mines on a drone carrier missile.