Is it actually true that “the moon is beautiful, isn’t it” could be a confession?

Is this a widely known thing in japan? I feel like it’s brought up a lot within anime fandoms ,but when I asked my Japanese mother about it, she said she didn’t get it. From what I read, it’s a literature reference so maybe it’s just as popular as someone referencing romeo and juliet?