I personally don't accept that one must have a "calling" to become a nurse (and there's a whole lotta threads on that topic if you feel like going there). That said, a student would find it rather difficult to get THROUGH nursing school without the ability to not only work at the bedside, but do it WELL.
An instructor who sees a student withdrawing from physical care is not going to let that student finish, period. You don't have to become an angel of mercy or a martyr, don't have to declare you love inserting foleys above all else in the world, but you DO have to make your patients feel that you enjoy taking care of them. And that's mighty hard to do when you don't want to be there.
Like llg said, please reconsider your options. It'd be a shame to get into school, through pre-reqs, spend gobs of money and time only to be dismissed as a poor nursing candidate.
Best of luck to you in what it is you REALLY want to do