Question: What happens if DBS-404 is on 1 hull left, and uses its card effect which reduces its hull to 0, Is it destroyed and would the attack end?
Answer: Yes. As soon as DBS-404 has been reduced to 0 hull points, it is immediately destroyed, and the attack ends without resolving. However, if it is performing a "Counter" attack, the attack will resolve completely.