It's not a conspiracy theory, most of us who support the vaccine just get fed up by people who don't and flout wearing masks, etc. This isn't something that has slowly been inserted into my brain via the TV or the internet. I fully supported the vaccine when it was first proposed.
I've worked with public health scientists as well as having close relatives who were scientists as well as being married to a former scientist so grasping the need for a vaccine as well as the need for PPE was a no-brainer.
I understand that even though I may be vaccinated I might still get COVID. Nothing is foolproof, there are many, many stories and articles in the media stating this fact - I also know that medication has side effects too. Again us pro-science folks tend to use critical thinking so we understand that there are risks.
I've seen pictures of my scientist-relatives and my wife when she was a scientist in their workplaces, and they never wore one-piece black jumpsuits or worked in some huge underground bunker. I try and put my trust in people who have studied this their whole careers, rather than a bloke who's a pastor or some random church or a disc jockey who's trying to keep his listener figurers up by being controversial.
So why then do you fundamentally not trust people who have dedicated their entire lives to try and preserve yours?
Because, as you yourself say, science is not fool proof. Science is only fact until proven otherwise and is proven otherwise often.
I have twin step brothers who are victims of thalidomide. I had an uncle who was diagnosed with type 1 diabetes then when in hospital for hip replacement, was told he had been incorrectly diagnosed with diabetes and taken off his medicine. Shortly thereafter, died as he lay there in that very same hospital bed in a diabetic coma until he passed away at the age of 36.
I remember watching the news as Scientists swore an oath in front of congress that cigarettes were not addictive and did not cause cancer.
The list of examples where the public have been lied to by our own experts and our own governments are practically endless.