Yes, relays and clients can choose to hide (rather than delete) or ignore a request.

But most mainstream clients and relays will remove from public view in some way or another.

But yeah, think before you post anything online applies to Nostr as well