Would someone have the guts to hang this on a wall?
I would.
In the bedroom? Yes. A reminder to do something in bed besides sleeping and eventually a reminder of times when lust was a much stronger driving force in life.
In the office? Yes. There is nothing wrong or offensive in the picture; your mind is getting into the gutter by itself.
In the living room? Yes. Great conversation starter.
By the front door? Yes. Oh yes. The face on anyone knocking unsolicited when spoting that strategically placed painting.