Not a carer myself but I've spoken to my Mum's home carers a lot as has she... I think it's a really tough job and certainly not well rewarded either in monetary terms or gratitude/appreciation (carers work just as hard as nurses IMO, long hours and hard physical graft, lots of travel/driving around unlike most nurses, and they don't get anything like the love and respect - not saying nurses are universally appreciated either mind!)
That being said I do think if you are the right kind of person and in the right job it can be really rewarding. It's vital you are with a good agency who will support and train you properly (times are very tough, local authorities have been forced to cut social care budgets to a bare minimum so all care agencies are really hard pushed to turn a profit or even stay sustainable, but within that there are those that do their level best with what they have and recognise how important their staff are, and there are those that do everything possible to squeeze every last penny's worth of labour from their staff and don't care much about whether people including their own clients suffer in the process, IYSWIM? Ask around your local area and talk to staff/clients and you'll get an idea which are which pretty quickly!
The personal/intimate care elements I think actually most people get used to pretty quickly (providing you aren't an unduly squeamish person) and weirdly I think it's somehow easier doing care as a job for a client rather than for your own relatives as you can take a lot of the emotion out of it and maintain a level of kindly/compassionate detachment! I think what a lot of carers find harder is either when the clients they get attached to are ill, suffering, lonely or sad or in bad living situations and they can't do much to help (particularly given aforementioned budgetary constraints which might mean you are limited to seeing them in a few 15 minute chunks per day), or ultimately when clients pass away which is really tough. Or the other things which is hard in other cases is where the carers are not treated with much respect or kindness by the client or the client's family - sadly I have heard stories of carers being verbally abused, unjustly accused of theft or abuse themselves or even physically assaulted . Sometimes this can be a side effect of the client's dementia/confusion or sometimes people are just arseholes esp to women (most carers are women, sorry if you are not but same can apply to men too!) in domestic/caring/subordinate type roles...
All in all you might love it and find it totally fulfilling, and ultimately I don't think the training period is too much of a commitment/lengthy so providing you go into it with eyes open why not give it a try?! The other thing you could look into is a job in a care home, although that may mean working with sicker residents and different pressures, at least you have other people/staff around for support? Sometimes there can be more opportunities for training and career progression in a home environment than dom. care also?