Assuming you are based in the UK then it is perfectly possible to be a professional pilot. I am CVD and have a restricted Class 1 medical. My CPL has no restrictions - the restrictions are all on the medical. My medical limits me to day only, no public transport and I must have a radio when flying at an aerodrome with ATC.
There is no VFR only restriction and I have an IR(r). It is now possible to get a full EASA IR as well, because the night rating/qualification pre-requisite has been dropped - but of course you will not be allowed to use it at night.
I work as an FI. I don't find the night restriction particularly onerous, but it is pointless and irritating so I might have a go at the CAD test sometime just to see if I can pass it. I am way too old for a public transport job but I would like to do the occasional night flight and instruction.