Slippery Pete, as you know aviation is a tough gig with a reality gap between the sales pitch and the job market.
Sugar coating it isn't going to help anyone.
It sounds like the OP has a realistic grasp on it and that is why there are doubts creeping in.
BTW I have been training CPLs for 20+ years. Some people get quite far along and decide it's not for them. I would never recommend taking out a massive loan to do it for that reason.