Is the interconnect just a standard RCA analogue interconnect & what is the maximum length the cable can be?Yes, it's a standard RCA
That table comes with a cable, try it first and if you need something longer, look at Blue Jeans Cables.
Cables for your turntable should have low capacitance and be as short as possible. If you need a longer cable, Blue Jeans LC-1 has very low capacitance.
I find all the comments in this thread about whether you should or shouldn't get into vinyl interesting. It's good that people are pointing out things that might not be readily apparent like the cost of the vinyl itself or that you won't really get the "vinyl experience" without making more of an investment than you are, record cleaning, etc.
I think your approach is good, you'll figure out if you enjoy vinyl or not without spending too much money. If you do enjoy it, you will most likely find yourself wanting to improve the "experience" and you can then go down the rabbit hole.
What I would not do is try to upgrade that turntable or any entry level (around $200-$300) table too much. If you decide you'd like to pursue better sound quality, you can take a big step up buying a used table for $500-$1000, and you can start to get to that "vinyl sounds better than digital" point around $2K (IMHO), and then of course the sky is the limit from there.
When you get into higher end tables you don't have to fuss around too much if you don't want to as long as you have a decent hifi shop near you. They mount cartridges and set up your table for you if you get into something more high end. There are some pretty decent higher end "plug and play" options available that aren't fussy, the Clearaudio Concept is one that comes to mind. There are a number of other options.