My urine looks very bloody, I have a kidney stone but it hasn't passed yet and its been two weeks, go to the doc?

Bloody urine. Yes , go to a urologist.
Ureteral stone. The size of the stone does not correlate well to the intensity of the pain. The nearly unbearable pain of "ureteral colic" is from spasm of the muscular ureter. Although 50% probability to pass on its own within a few days, a 6mm stone sometimes will get stuck and fail to progress. Usually after 5 days, i recommend having the stone extracted with a ureteroscope as an outpatient.