The Moonshine Greatsword has modest scaling in all stats, and especially high intelligence scaling. Therefore, it serves as a great melee weapon for runs that prioritize intelligence and magic damage.
Trivia
The Moonshine Greatsword is a reference to the Moonlight Greatsword, a famous blade that recurrently appears in FromSoftware games, including Dark Souls, Bloodborne, and Elden Ring.