The station seems like a bit of a missed opportunity, which is a shame.
It could have served as a park and ride for London site for quite a wide area to the North of Cambridge... but not on the service levels it's seeing
Also, it seems to me that a lot of the published timetables are a bit unusable, whether online journey planners, the NR pocket timetable or printed
The only timetable that shows all the services between Cambridge and Cambridge North is in the Cambridge to Ely, Peterborough & Norwich section of the AGA regional timetable. This shows connections to Liverpool Street and Stansted Airport, so is useful and usable to that extent.
I started trying to put my own together for Kings Cross, because I couldn't find one anywhere (it's sad that the National Rail Timetable doesn't show connections
)
Apart form the lack of services to Waterbeach and the dodgy connections to Peterborough the particularly sad thing I found is that the connections from the KX fasts that don't go to it aren't very good at all. In particular, the only time there is a one hour gap the service from KX to CMB is... 1614 to 1714!!!
This happens because the 1644 arrives in Cambridge at 1730, which doesn't allow enough time to connect onto the 1732. It's a shame they haven't been able to hold the 1732 back three mins to make this a viable connection, as the 1732 is a GN service that terminates at CMB and doesn't need to leave again until 1747.
It's a similar story throughout the day; the xx44s from London arrive at xx30, just missing the xx28s to CMB. However at other times of day it's generally possible to use xx52 services from CBG to CMB that have come in from Liverpool Street, which only make the journey around 19mins longer than a direct service would have been.
The overall effect of this is unfortunate. Unless you know which train you'll be getting back from London the average journey time from CBG to CMB (including connection times) is something like 15 mins (or longer if your potential departure times include 1615-1715). This means that unless CMB is more than 15 mins closer to you than CBG you may be better off going to CBG. If you have a bike that almost certainly means you're better off going to CBG...
One of the other great prospects for this station would be connections from the Guided Busway. It offers an entirely off road connection to St Ives in just 22mins, via the villages along the way and the Northstowe new town that just just started to see its first residents. There's therefore potential for a bus link to serve thousands of non rail connected residents and be super reliable.
Unfortunately the "N" service introduced to serve the station generally starts short of St Ives at Longstanton P&R, and is timetabled to continue to do a loop in the city center and return to Cambridge North in a highly ambitious 26 mins (even at rush hour). Further; it looks like the service only has 6 mins recovery time for each full return journey. Obviously serving the city centre gives the service a higher chance of commercial success, but I fear that the lack of reliability this will introduce will mean that rail passengers would be better off taking the longer and more frequent journey to Cambridge Station, from where they can take their chances at a far better choice of trains and selection of return buses.
Finally, bus links from within Cambridge itself are really very limited. The main service is this one:
https://tiscon-maps-stagecoachbus.s3.amazonaws.com/Timetables/East/HYBRIDS/CA - CITI 2 - HYBRID.pdf (second half of the document). There's nothing from the remainder of the north of Cambridge at all (and the location of the station means that it would be hard to modify any other routes to go there). There's really only a few hundred yards of that route that aren't either places from where you'd be better going to Cambridge station or places from where you could walk to Cambridge North! Also, I suspect they will quickly realise that diverting the service away from the Science Park has been a bad idea as far more people would have wanted to take the bus there!