Red dots mean that the area has two exits instead of one. It opens alternate paths to other levels that you must complete. Keys count as an alternate exit. If you find a key in any level, it has a red dot.
To get credit for all 96 goals, you must get all exits for every course. Bowsers castle does not count.