I have managed to sort it out. As stated earlier, next-mdx-remote isn't working with the latest version of Next.js, but there is next-mdx-remote-client which can be used instead. A few changes need to be made but it isn't a lot overall.

Here is the repository for next-mdx-remote-client: https://github.com/ipikuka/next-mdx-remote-client