Well, must be hard to sleep though, trying to lay down with such horns. But now that they can go insubstantial and pass through things, I have this mental image of them being magical now. Where if a person reaches up to touch them, he can make them solid if he wants to, but the goddess's blessing made it so they are like ghosts. Looking solid, but actually feather-light and insubstantial. Which means people still see them, but he barely feels them and they don't get in the way. :-) Heh, and yet he's also learned to use them as a defensive weapon IF necessary, where they hit only the bad guys and slide harmlessly through the innocent as if a wind through leaves.

At least that's my head-cannon.