Heard the same from HV for both kids.
Thing is my HV is lovely, so I would not want to offend. However She is good 15+ years older than me and back then the formula was the norm. So in a way even though they have heard the guidance it is not part of their inner belief. They think BFng past certain age wierd (1 y for sure) and even before that would suggest dropping it if there are any problems. By problems I mean Mum not getting enough sleep, baby dropping off the centile (imagine when we used older formula charts as well), baby bopping on and off the breast, etc. GPs similarly believe that past 6 months and certainly past 1 year there are no imummological benefits. Around 6-8 momths HVs are worried that the babies who nurse are Not getting enough solids and that their weaning onto solids might be affected. Then any weaning difficulties (say teething, or a bug, so kid eats less) will lead to discussion on appropriateness of BF. Equally other things blamed on BF are: baby is dependent on mother, separation anxiety, how will he/she transition to nursery, and night wakings.
Any wonder then that women give up. Here if I say that they give uo for lack of support I would be accused of being prejudiced. Many women who formula feed say that they feel judged and that on the contrary they feel that 'breast is best' message from health proffessionals made them feel inadequate and nearly bullied into BF.
My view is that in the first instance we need to accept that as human species we process information easier in simplified terms, hence the gravitation towards simple messages which sadly end up marginalising people. Hence the coined slogans, steriotypes, and ready made judgements. Secondly, accurate info is IMO best. Accurate information without bias. Let the mum decide. Then whatever she decided, that is what goes and needs to be supported. The guilt or constant second guessing is very unhelpful and undermining, however well intentioned. IMO women who actually go to see HV have their child's best interest at heart and often already have thought through a few things.
As for feeding for own comfort - I have heard that a bit and I think of it as both judgemental and a form of emotional manipulation.