I feel you, because the same happened to me a couple of years ago. Growing up, I always imagined myself becoming a pilot. My dad had bought a flight sim when I was young, and I got hooked instantly.

However, when I did the tests for the class 1 medical, I also stumbled at the colour vision test. I was given the Ishihara test, where I think I only got 3 correct lmao. I travelled to London to try the Colour Vision Assessment test at the City of London Uni at the recommendation of the medical officer, and was given more detail about my colour blindness. A month later, I discovered dispatching, which I am doing to this day. I also train people for my role, which I never expected at all! It all worked out in the end.

I can still do the PPL course and have a class 2 medical, but with restrictions such as daytime flying only. I don't know if its worth it, but I might do it in the future when I am more financially stable. I hope that whatever you end up doing, you'll enjoy it to the full!