first let's beggin with how the dialogue is written, as expected from an old but not so old game the dialogue is pretty nice, not overly flowery but not too plain or robotic.
as far as i remember(and please forget me because last time i played this game in english was years ago) aria of sorrow lacks any "localization" issues with most things staying as close as possible to the original japanese script, besides one of the characters having a somewhat noticeable way of speaking(which he also somewhat has in the japanese dialogue) nothing here seems wrong at first sight, no memes, no heavy slang nothing.
but then again im not an expert in this field so i might be missing some stuff(ene if you're seeing this feel free to correct me)
as for the story of the game this one takes a quite different approach from other games, unlike other castlevania games where there is a very well defined battle between good and evil aria of sorrow has more mystery to it.
dracula is dead in this game and for good, he's gone the only thing left behind of him being his castle and the remnants of his powers which have been sealed in a solar eclipse, our protagonist soma along with his beloved mina are both transported into the castle against their will and as mentioned before for no apparent reason.
in the castle you'll also come across other characters, most of which seem to have some sort of connection to the now dead dark lord, these characters will help soma through his journey on discovering who he is and why he was summoned to the castle
now of course SPOILERS FOR AN OLD AS FUCK GAME
soma being the reincarnation of dracula instead of having a blood connection to the vampyre hunter clans is an approach i really like and i think that fact also makes other characters shine specially arikado(who we all know is alucard) and julius belmont
for alucard it's endearing that he's willing to give a seccond chance to the soul of his dad and he's constantly looking over soma to make sure he doesn't commit the same mistakes his past himself made
as for julius holy shit isn't he the best belmont period, him being old by the time aria of sorrow just makes him even cooler being not only the hardest boss in the game but also the fact that he
1. was holding back the whole time during his bossfight
2. is the only belmot who was capable of killing off dracula for good in his prime
3. he survived draculas castle out of his prime, without a weapon and with amnesia up until near the end of the game
the guy is a certified badass and it makes me sad that we probably will never get a game where he is the protagonist
overall the story of aria of sorrow is quite interesting, it isn't ground breaking maybe but it's an interesting spin to the castlevania formula, it's no longer about fighting the darkness outside but instead about fighting the darkness within yourself.