It was discovered last year embedded at a depth of 12 metres (39 feet) with just its nose sticking out during dredging close to the port city of Swinoujscie in northwest Poland.
Assuming the part about it being nose-up isn't a reporting error - that's very curious. Although dredging may have disturbed it, it would be unlikely to rotate it 180 degrees while leaving the bomb almost entirely covered.
I wonder if the tail fins detached/failed, and the bomb tumbled instead of heading in nose-first. That could also explain why it didn't detonate - landing tail first.